COUNTA
Counts the number of defined cells in a given range.
Syntax
=COUNTA(Value1, [Value2...ValueN])
Arguments
| Name | Type | Description |
|---|---|---|
| Value1 | Range | Cell or range to check for defined cells. |
| Value2...ValueN (optional) | Range | Additional cells or ranges to check. |
Return
| Type | Description |
|---|---|
| Number | Amount of defined cells. |
Examples
| A | B | C | |
|---|---|---|---|
| 1 | 42 | hi | |
| 2 | FALSE | 0 | |
| 3 |
| Formula | Result | Comment |
|---|---|---|
| 1 | Single defined cell. |
| 0 | Cell in C1 has no value. |
| 4 | Range contains only 4 defined cells in A1, B1, A2 and B2. |
| 4 | Same as before but using multiple ranges. |