COUNTIF(C$42:C$65536;"=&$B$36")

--

Regards,

Peo Sjoblom

"Renata Lemos" <Renata wrote in message
...
Hi!

I need to count the cell ina range that have its value grater then a value
that I have in another cell. I´don´t know how to do that.

I tried doing

COUNTIF(C$42:C$65536;"=$b$36")

But it doesn´t work. This formula just works if I put a value and not a
cell
as an argument.

Does anybody know how I can do that?

thanks!!