COUNT(value1 [,value2] [..]) 
Returns the number of non blank cells in a list, table or cell range. 
value1  The first value. 
value2  (Optional) The second value. 
Remarks 
* This function includes hidden rows. * For an illustrated example refer to the page under Advanced Functions. * Arguments that are numbers are included. * Arguments that are zero are included. * Arguments that are dates are included. * Arguments that are logical values are excluded. * Arguments that are text are excluded. * If any cell references are empty, then these are excluded. (Row 5). * If any cell references contain an error, then that error is returned. * You can have a maximum of 255 arguments. * You can use this function to get the number of entries in a number field in a range (or array) of numbers. * You can use the COUNTA function to include logical values and text. * You can use the COUNTBLANK function to return the number of blank cells. * You can use the COUNTIFS function to satisfy multiple conditions. * You can use the COUNTVISIBLE  User Defined Function if you want to exclude hidden rows. * You can use the AGGREGATE function to exclude hidden rows. * This is similar to the AVERAGE function. * This is similar to the MAX function. * This is similar to the MIN function. * This is similar to the SUM function. * For the Microsoft documentation refer to support.office.com 

1  How many cells contain numerical values in the range "B1". Cell references to text are excluded. 2  How many cells contain numerical values in the range "B2". 3  How many cells contain numerical values in the range "B3". Cell references to dates are included as these are just numerical values formatted as a date. 4  How many cells contain numerical values in the range "B4". Cell references to empty strings are excluded. 5  How many cells contain numerical values in the range "B1:B3". 6  How many cells contain numerical values in the range "B1:B5". Cell "B5" contains a zero value. 7  How many cells contain numerical values in the range "C1:C2". Cell references that contain errors are excluded. 8  How many cells contain numerical values in the range "C3:C4". Cell references to logical values are excluded. 9  Is a blank cell considered to be a numerical value. Cell references to blank cells are excluded. 10  Is the number 40 considered to be a numerical value. Yes. 11  Is the text string "01/05/2016" considered to be a numerical value. Text representations of dates are numerical. Yes 12  Is the date 1/5/2016 considered to be a numerical value. Yes 13  Is the logical value in speech marks considered to be numerical value. No. 14  Is the logical value TRUE considered to be a numerical value. Yes. 15  Is the logical value FALSE considered to be a numerical value. Yes. 16  Is the text string "some text" considered to be a numerical value. No. 17  Is the empty string "" considered to be a numerical value. No. 18  Is the error generated by dividing by zero considered to be a numerical value. No 19  How many items are numerical values in the list (1,2,3,4,5). 20  How many items are numerical values in the list ("1","2","3","4","5"). Numbers in speech marks are included. 21  How many items are numerical values in the list ("1","2","3","4","5","01/07/2016"). Dates in speech marks are included. 22  How many items are numerical values in the list ("1","2","3","4","5",1/7/2016). Dates can be provided as values and these are included. 23  How many items are numerical values in the list ("1","2","3","4","5",TRUE). Logical values are included when passed in a list 24  How many items are numerical values in the array {1,2,3,4,5,""}. Empty strings are excluded. 25  How many items are numerical values in the array {1,2,3,4,5,"100"}. Numbers in speech marks are excluded. 26  How many items are numerical values in the array {1,2,3,4,5,TRUE}. Logical values are excluded when passed in an array. 27  How many items are numerical values in the array {1,2,3,4,5,"TRUE"}. Logical values in speech marks are excluded. 28  How many items are numerical values in the array {1,2,3,4,5,"01/07/2016"}. Dates in speech marks are excluded when passed in an array. 
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top