From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells

Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells

“

- [Instructor] It's important at times 2 to recognize when cells are blank. 3 It's also important at times to be able to tabulate 4 how many blank cells there might be. 5 This is a small amount of data 6 we're seeing on this worksheet, 7 columns A through G, only goes down to row 16. 8 But let's imagine a simple little test here 9 to see if a cell is blank or not. 10 Now, let's imagine that maybe 11 we're going to have some additional bonuses possibly, 12 additional thoughts related to the benefits package 13 that some people have here. 14 Let's make a simple test to see 15 if an entry in column F is blank. 16 We can do this with a function called ISBLANK. 17 Now, sometimes you'll use this with the IF function. 18 You can use it by itself as well, ISBLANK, left paranthesis, 19 I'm clicking cell F2, 20 and we don't have to put in the right parentheses. 21 I'll press Control + Enter here 22 and then simply drag it…

Contents