COUNTA
Syntax:
COUNTA ( argument-list )
Description: Counts the number of arguments that are not cell references, and the number of cells, referred to by arguments, which are not empty.
Arguments:
Name |
Type |
Description |
|---|---|---|
argument-list |
text |
Each argument in argument-list designates a value. Arguments with values of any type shall be counted. However, empty cells shall not be counted. If an argument is an array or reference, only values in that array or reference shall be counted. Empty cells and text values in the array or reference shall be ignored.
Note: : To exclude logical values, text, or error values, use the
3.17.7.52) function. ]COUNT (§ |
Return Type and Value: number – The number of arguments that are not cell references, and the number of cells, referred to by arguments, which are not empty.
example: