Counts the number of arguments that are not empty.
Syntax
COUNTA(value1,value2,...)
Value1, value2, ... are 1 to 30 arguments representing the values you want to count. In this case, a value is any type of information, including empty text ("") but not including empty arguments. If you do not need to count logical values, text, or error values, use the COUNT function.
Examples
|
Col1 |
Col2 |
Col3 |
Col4 |
Col5 |
Col6 |
Col7 |
Formula |
Description (Result) |
|---|---|---|---|---|---|---|---|---|
|
Sales |
12/8/2008 |
19 |
22.24 |
TRUE |
#DIV/0! |
=COUNTA([Col1],[Col2],[Col3],[Col4],[Col5],[Col6],[Col7]) |
Counts the number of nonblank arguments in the list (6) |
|
|
Sales |
12/8/2008 |
19 |
22.24 |
TRUE |
#DIV/0! |
=COUNTA([Col4],[Col5],[Col6],[Col7])) |
Counts the number of nonblank arguments in the last 4 rows of the list (4) |
|
|
Sales |
12/8/2008 |
19 |
22.24 |
TRUE |
#DIV/0! |
=COUNTA([Col1],[Col2],[Col3],[Col4],[Col5],[Col6],[Col7],2) |
Counts the number of nonblank arguments in the list and the value 2 (7) |
|
|
Sales |
12/8/2008 |
19 |
22.24 |
TRUE |
#DIV/0! |
=COUNTA([Col1],[Col2],[Col3],[Col4],[Col5],[Col6],[Col7], "Two") |
Counts the number of nonblank arguments in the list and the value "Two" (7) |
