description:
Count non-empty cells in a range. |
syntax:
=COUNTA( value1, [value2], …) |
required arguments:
value1 | The first value. |
optional arguments:
[value2] | The second value. |
example:
The following example counts cells that are not blank (in range A1:E2).
In this range only cells A1, B2 and E2 are not blank, so the function returns 3. |
notes:
You have to be careful because any value will be counted, even space. |
additional examples:
Count cells that are not blank. |
Remove blank rows. |
related functions:
COUNT |
COUNTIF |
COUNTIFS |
more resources:
Excel functions |
Excel formulas |
Excel 2013 Formulas |