Count blank cells.
  • range - required, range from which to count the blank cells



    The COUNTBLANK Function can be used to count the number of blank cells in a range. For example, will return the number of blank cells in the range from cell B5 to B15.

  • =IF(A1>30,"Overdue","")

    COUNTBLANK will also count empty strings as blank cells. For example, if the formula returns an empty string, COUNTBLANK will count this as a blank cell.


The COUNTBLANK function is used in Sourcetable to count the number of empty cells in a range of cells. It also counts cells with formulas that return "", though it does not count those with zero values.

  • COUNTBLANK takes one argument, a cell range.
  • The cells in the range must be empty for COUNTBLANK to count them.
  • Cells with text, numbers, errors, spaces, or other characters will not be included in the count.

Frequently Asked Questions

What is the COUNTBLANK function?
The COUNTBLANK function counts the number of empty cells in a range.
What is the syntax of the COUNTBLANK function?
The syntax of the COUNTBLANK function is COUNTBLANK(range).
What does the COUNTBLANK function count?
The COUNTBLANK function counts cells with formulas that return "" and empty cells.
Does the COUNTBLANK function count cells with zero values?
No, the COUNTBLANK function does not count cells with zero values.

Get smart about your data.

Connect, sync, and query data from 37+ data sources, without code.
Get unlimited access free for 14 days.