How to Count Cells that are Space

To count the number of cells that are space, you can use the COUNTIF function with space as the count criterion.

Formula:

= COUNTIF(Range," "), space is required in quotation marks

Explanations:

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

– Space (" ") is required.

Cautions:

The formula counts the cells that are space only, not the cells with spaces and other characters.

Example: To count how many cells that are space in Column A.

– Range: Column A (A2:A8)

– Space " ": the criteria.

= COUNTIF(A2:A8, " ")
One space is required in quotation marks.

The result returns 2 and there are 2 cells in column A that are space.

Download Count Cells that are Space

Leave a Reply