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

25092017

=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

25092017

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.
Dear readers, after reading the Content please ask for advice and to provide constructive feedback Please Write Relevant Comment with Polite Language.Your comments inspired me to continue blogging. Your opinion much more valuable to me. Thank you.