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 COUNT function to return the number of non blank cells in a list, table or cell range. * You can use the COUNTIFS function to satisfy multiple conditions. * You can use the COUNTAVISIBLE  User Defined Function if you want to exclude hidden rows. * 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 

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. 
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top