How to Count Cells that are Blank

COUNTIF Function| COUNTBLANK Function

To count the number of blank cells, you can use the COUNTIF function or the COUNTBLANK function.

1. COUNTIF Function

Formula:

= COUNTIF(Range, "")

Explanations:

– The range is required, which will be the range of cells that you want to count;

– Blank "" is required.

Cautions:

There is no space in the quotation mark (""), otherwise, you will get errors.

Example 1: To count how many blank cells in column A.

– Range: Column A (A2:A8)

– Blank "" (criteria): quotation mark "".

= COUNTIF(A2:A8,"")
There is 2 blank cells in column A.

2. COUNTBLANK Function

You can also use the COUNTBLANK function to count blank cells.

Formula:

=COUNTBLANK(Range)

Example 2: To count blank cells in column A

=COUNTBLANK(A2:A8)
There are 2 blank cells in column A.

Download Count Blank Cells

Leave a Reply