counting cells with a formula

  • Thread starter Thread starter solo_razor
  • Start date Start date
S

solo_razor

hi,

I want to count cells with a specific value. I don't know how i can put
this in a formula, can anybody help me with this problem.

regards,
 
solo_razor said:
hi,

I want to count cells with a specific value. I don't know how i can
put this in a formula, can anybody help me with this problem.

regards,
Click to expand...


The command you need is COUNTIF...

=COUNTIF(range of cells, condition in "")

e.g.

=COUNTIF(A1:A200, ">10")

will return the number of cells in the first 200 rows of column whose value
is over 10.

Hope this helps...
 
Back
Top