COUNTIF Blank
If you want to count blank cells in a certain range, use the formula with a wildcard character for text values and with the “” criteria to count all empty cells.
Formula to count blank cells:
COUNTIF(range,”<>”&”*”)
Note: Asterisk(*) is used because it matches any sequence of text characters, the formula counts cells not equal to *, which doesn’t contains any text in the specified range
COUNTIF formula for blanks (all value types):
COUNTIF(range,” “)
Excel COUNTIF Function
The COUNTIF function in Excel is used to count the number of cells that match a single condition applied. It can include Dates, Numbers, and Texts. It uses various logical operators like <(Less Than), >(Greater Than), >=(Greater Than or Equal to), <=(Less Than or Equal to), =(Equals to), and <>(NOT) for matching the condition. It also uses some wildcards like * and ? for partial matching.