COUNT(value1 [,value2] [..])

Returns the number of non blank cells in a list, table or cell range.

value1The 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.microsoft.com

 ABC
1=COUNT(B1) = 0"Text"#DIV/0!
2=COUNT(B2) = 114.3#REF!
3=COUNT(B3) = 17/1/1977TRUE
4=COUNT(B4) = 0""FALSE
5=COUNT(B1:B3) = 20"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. 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.
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top