### 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

 A B C 1 =COUNT(B1) = 0 "Text" #DIV/0! 2 =COUNT(B2) = 1 14.3 #REF! 3 =COUNT(B3) = 1 7/1/1977 TRUE 4 =COUNT(B4) = 0 "" FALSE 5 =COUNT(B1:B3) = 2 0 "100" 6 =COUNT(B1:B5) = 3 7 =COUNT(C1:C2) = 0 8 =COUNT(C3:C4) = 0 9 =COUNT(C6) = 0 10 =COUNT(40) = 1 11 =COUNT("01/05/2016") = 1 12 =COUNT(1/5/2016) = 1 13 =COUNT("TRUE") = 0 14 =COUNT(TRUE) = 1 15 =COUNT(FALSE) = 1 16 =COUNT("some text") = 0 17 =COUNT("") = 0 18 =COUNT(10/0) = 0 19 =COUNT({1,2,3,4,5}) = 5 20 =COUNT("1","2","3","4","5") = 5 21 =COUNT("1","2","3","4","5","01/07/2016") = 6 22 =COUNT("1","2","3","4","5",1/7/2016) = 6 23 =COUNT("1","2","3","4","5",TRUE) = 6 24 =COUNT({1,2,3,4,5,""}) = 5 25 =COUNT({1,2,3,4,5,"100"}) = 5 26 =COUNT({1,2,3,4,5,TRUE}) = 5 27 =COUNT({1,2,3,4,5,"TRUE"}) = 5 28 =COUNT({1,2,3,4,5,"01/07/2016"}) = 5

 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. Yes12 - Is the date 1/5/2016 considered to be a numerical value. Yes13 - 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. No19 - 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 list24 - 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.