Count a certain value

C

chris

I want to count how many times the number 2 (for example) is in a column.

There must be some type of COUNT function (like count nonblank cells that
contain the value "2", like an ACOUNT) but I can't find it and he help
doesn't show me.

Thanks!
 
P

Pete_UK

Try this:

=COUNTIF(A1:A100,2)
or
=COUNTIF(A1:A100,B1)

where B1 contains the number you are interested in.

Hope this helps.
 
C

chris

Perfect, thanks!

Pete_UK said:
Try this:

=COUNTIF(A1:A100,2)
or
=COUNTIF(A1:A100,B1)

where B1 contains the number you are interested in.

Hope this helps.
Click to expand...
 
Top