Article updated on January 26, 2018

The COUNTA function counts the non-empty or blank cells in a cell reference.

The picture above demonstrates the COUNTA function entered in cell F3. The evaluated range is C3:C10, two of the cells contains formulas, three cells seem to be empty but only one is in fact empty.

Cell C4 has a formula that returns a blank, note that the COUNTA function considers this cell not empty. Cell C7 has a space character and is therefore counted. Only cell C6 is empty.

Excel Function Syntax

COUNTA(value1, [value2], ...)


value1 Required. A cell reference to a range for which you want to count not empty values.
[value2] Optional. Up to 254 additional arguments like the one above.


The COUNTA function counts errors as not empty.