Count a certain value

[Guest]

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!

 

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

 

[Guest]

Perfect, thanks!

Try this:

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

where B1 contains the number you are interested in.

Hope this helps.