Excel FunctionsLesson 79Free preview
COUNTBLANK
This lesson is part of Excel · All levels
Summary
COUNTBLANK is an Excel function that calculates the number of empty cells in a range. A cell is considered empty if it contains nothing or contains a formula that produces empty text. This function is useful for monitoring the completeness of data inputs.
Key points
- COUNTBLANK counts the empty cells on the given range
- The formula that produces "" is also considered blank by COUNTBLANK
- A cell containing spaces is not considered empty
- Simple relationship: the number of cells = COUNTA + COUNTBLANK
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.