COUNT

“COUNT”

Used for – “COUNT” function in MS Excel is used count the number of cell that contain numbers in given array or range.

Syntax – COUNT(value1, [value2], …)
             value1 – It is a cell / array  / range for which you wants to count the number of entries entered in number. It is a compulsory field and if you did not fill any value excel will not proceed further and if you enter only comma(,) in the formula excel will consider two values with number zero.

            [value2] – It is same as of value1 and is an optional field. You can add upto 255 values in this function.

Example – Following example will clear the COUNT function:-

In below table column A contains some data.

	A	B	C	D	E	F	G	H
1	25-09-2017		=COUNT(A1:A9)
2	51		=COUNT(A6:A8)
3	20.4		=COUNT(A1:A4)
4	excelwithease		=COUNT(A1:A3)
5	TRUE		=COUNT(A4:A9)
6	YES		=COUNT(A4:A9,2)
7	#VALUE!
8	#DIV/0!
9

Here cell A1 contains date, cell A2 & A3 contains numbers, cell A4 to A6 contains text values and cell A7 & A8 contains errors and column C contains count function for different selection.

And result you get as under:-

	A	B	C	D	E	F	G	H
1	25-09-2017		3
2	51		0
3	20.4		3
4	excelwithease		3
5	TRUE		0
6	YES		1
7	#VALUE!
8	#DIV/0!
9

NOTE :- Please do care and remember the following points whenever you use COUNT function :-

•  Only 255 values can be provided for COUNT function.
• Before using COUNT check all the numeric values are in number / date / time format if the values are in text format they will be ignored during the count.
• The text values or logical values or error values or empty cell will be ignored and are not count.

• Tweet
• Share
• Share
• Share
• Share