From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Tabulating blank cells with the COUNTBLANK function

Tabulating blank cells with the COUNTBLANK function

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Tabulating blank cells with the COUNTBLANK function

- In this worksheet called COUNTBLANK, we've got a list of about 100 rows or so here, and we're curious about how many people do not have benefits. And we can come up with that answer, if we could count the blank cells in Column F. So a formula over here in cell K2, =countblank. This is one of those longer functions. When you first see it in the list, so that you can click it and tab it into place, you can certainly do that, make it a bit faster. Click Column F, total blank cells in Column F, well perhaps that's not the answer we want, it counts all those empty cells in Column F below the data as well as the empty cells within the earlier rows here, where we see blanks as well. So let's modify this. And we can certainly count the blanks if we're looking in cells F2 down to F100, that's the last row that actually has data in the list. How many empty cells do we see there? 28. So that's valueable information. However, if this list grows and or shrinks over time, we'd have to be…

Contents