counting cells with a formula

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

 

[The Red Cardinal]

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,

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