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 |
