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.