COUNTA(value1 [,value2] [..])

Returns the number of non blank cells in a list, table or cell range (including logical values and text).


value1The first value.
value2(Optional) The second value.

Remarks

* This function is identical to the COUNT function except that logical values and text are included.
* This function includes hidden rows.
* Arguments that are numbers are included.
* Arguments that are zero are included.
* Arguments that are dates are included.
* Arguments that evaluate to True or False will be counted as 1.
* Arguments that are text are included and counted as 1.
* If any cell references contain an error, then these are included and counted as 1.
* If any cell references are empty, then these are excluded. (Row 7).
* You can have a maximum of 255 arguments.
* You can use the COUNTIF function to satisfy one condition.
* You can use the COUNTIFS function to satisfy multiple conditions.
* You can use the AGGREGATE function if you want to exclude hidden rows.
* This is similar to the AVERAGEA function.
* This is similar to the MAXA function.
* This is similar to the MINA function.
* For the Microsoft documentation refer to support.office.com

 ABC
1=COUNTA(B1) = 1"Text"#DIV/0!
2=COUNTA(B1:B2) = 214.3#REF!
3=COUNTA(B1:B5) = 57/1/197720
4=COUNTA(B1:C5,10,20) = 11""True
5=COUNTA({1,2,3,4,5}) = 510 
6=COUNTA(C1:C4) = 4  
7=COUNTA(C1:C5) = 4  
8=COUNTA(TRUE,FALSE,0,1) = 4  
9=COUNTA({TRUE,FALSE,0,1}) = 4  
10=COUNTA({12,14,14},19,235) = 5  
11=COUNTA({1,2,3,4,5,"text",TRUE},B1) = 8  
12=COUNTA({1,2,3,4,5,"01/07/2016","some text",TRUE},B1) = 9  
13=COUNTA({1,2,3,4,5,"01/07/2016","some text",TRUE},B1,#N/A) = 10  
14=COUNTA({1,2,3,4,5,"01/07/2016","some text",FALSE},B1,#N/A) = 10  

1 - How many cells contain a number, date, text representation of a date, text, logical values or errors in the range "B1".
2 - How many cells contain a number, date, text representation of a date, text, logical values or errors in the range "B1:B2".
3 - How many cells contain a number, date, text representation of a date, text, logical values or errors in the range "B1:B5".
4 - How many cells contain a number, date, text representation of a date, text, logical values or errors in the range "B1:B5" and the list (10,20).
5 - How many items are there in the list {1,2,3,4,5}.
6 - How many cells contain a number, date, text representation of a date, text, logical values or errors in the range "C1:C4". Notice that both the error values in cells "C1" and "C2" are counted.
7 - How many cells contain a number, date, text representation of a date, text, logical values or errors in the range "C1:C5". Notice that the blank cell C5 is empty and is not counted.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top