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

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

 value1 The 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

 A B C 1 =COUNTA(B1) = 1 "Text" #DIV/0! 2 =COUNTA(B1:B2) = 2 14.3 #REF! 3 =COUNTA(B1:B5) = 5 7/1/1977 20 4 =COUNTA(B1:C5,10,20) = 11 "" True 5 =COUNTA({1,2,3,4,5}) = 5 10 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.