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!
|