COUNTBLANK

Formulas / COUNTBLANK
Count blank cells.
=COUNTBLANK(range)
  • range - required, range from which to count the blank cells

Examples

  • =COUNTBLANK(B5:B15)

    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.


Summary

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.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV