Count a certain value
 

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!

Count a certain value
 

Try this:

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

where B1 contains the number you are interested in.

Hope this helps.

Pete
chris wrote:
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!

Count a certain value
 

Perfect, thanks!

"Pete_UK" wrote:

Try this:

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

where B1 contains the number you are interested in.

Hope this helps.

Pete
chris wrote:
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!