COUNTA 
COUNTA(value1 [,value2] [..]) 
Returns the number of numerical values 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 cells. * Arguments that are numbers are included. * Arguments that are zero are included. * Arguments that are dates are included. * Arguments that are cell references to cells containing logical values are included. * Arguments that are arrays containing logical values are included. * Arguments that are just logical values are included. * Arguments that are cell references to cells containing text are included. * Arguments that are arrays containing text are included. * Arguments that are just text are included and counted as 1. * If any cell references are empty, then these are excluded. (Row 7) * If any cell references contain an error, then these are included and counted as 1. * You can have a maximum of 255 arguments. * You can use the COUNTAVISIBLE  User Defined Function to exclude hidden cells. * This is similar to the AVERAGEA, MAXA and MINA functions. * For the Microsoft documentation refer to support.microsoft.com * For the Google documentation refer to support.google.com 

1  How many of these values are numerical. 2  How many of these values are numerical. 3  How many of these values are numerical. Zeros are always included. 4  How many of these values are numerical. 5  How many of the values in this array are numerical. 6  How many cells contain numerical values in the range "B1:B3". 7  How many cells contain numerical values in the range "B1", "B2" and "B3". 8  How many cells contain numerical values in the range "B1", "B2", "B3" and "B4". B4 is empty. Empty cells are always excluded. 9  How many cells contain numerical values in the range "B1", "B2", "B3" and "B5". B5 is zero so this gets included. 10  How many cells contain numerical values in the range "B1", "B2", "B3" and "B6". B6 is text so this gets excluded. 11  How many cells contain numerical values in the range "B1", "B2", "B3" and "B7". B7 is a logical value so this gets excluded. 12  How many cells contain numerical values in the range "B1", "B2", "B3" and "B8". B8 is a date so this gets included. 13  How many cells contain numerical values in the named range that refers to the range "B1:B3". 14  How many cells contain numerical values in the range "B5", "B6" and "B9". B9 contains an error so this gets excluded. 15  How many of these values are numerical (2, "3"). The text representation of a number is included. 16  How many of these values are numerical (2, "some text"). Text values passed as arguments are excluded. 17  How many of the values in this array (2, "some text") are numerical. Text values inside arrays are excluded. 18  How many of the values (2, TRUE) are numerical. Logical values passed as arguments are included. 19  How many of the values (2, FALSE) are numerical. Logical values passed as arguments are included. 20  How many of the values in this array (2, TRUE) are numerical. Logical values inside arrays are excluded. 
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top