Counting Empty Cells

Learn how to count the number of empty cells in a selected worksheet region.

* Please note: There is a mistake in the last slide, it should have been:
"The result shows how many cells in the selected range are empty."

The COUNTBLANK function is very useful to point out how much data is missing from your reports.

For example, you are a teacher with a class of students, and you wrote down their test scores in your spreadsheet, but not all of students took the test.
You wish to know: How many students are still missing their score? For this you can write a COUNTBLANK function and include the region of the table that contains their scores. The outcome will give you the number of students without a score.