COUNT

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 cells.
* 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 to exclude hidden cells.
* You can use the AGGREGATE function to exclude hidden cells.
* 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

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