Cells that contain text, numbers, errors, spaces, etc.
Formulas that return an empty string ("")arecounted as blank.
COUNTBLANK takes just one argument, range, which must be a cellrange.
Note that cell B12 is not included because it contains a space character (" “).
Formulas that return empty strings
TheIF functionis often used to return empty strings.
However it’s worth noting thatCOUNTAandCOUNTIFSwill count B1 asnot emptyin the same case.
In other words they will see the empty string ("") returned by IF asnot blank.
Invisible characters
Some cells look empty, but actually contain invisible characters.
COUNTA does not count empty cells.
COUNT Function
The Excel COUNT function returns a count of values that are numbers.
Numbers include negative numbers, percentages, dates, times, fractions, and formulas that return numbers.
For example, if A1 contains “apple”, ISBLANK(A1) returns FALSE.
