[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
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 |
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 COUNT (§3.17.7.52) function. end note] |
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:
COUNTA(1,2,3,4,5) results in 5
COUNTA({1,2,3,4,5}) results in 15
COUNTA({1,2,3,4,5},6,"7") results in 7
COUNTA(10,E1), where E1 is an empty cell, results in 1, as E1 is ignored
COUNTA(10,E2), where E2 contains TRUE, results in 2, as E2 is counted
end example]