COUNTIF > CELL VALUE

[Renata Lemos]

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

 

[Peo Sjoblom]

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

 

[Andy Brown]

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.

Try:

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

HTH,
Andy

 

[Rob]

Renata,

This will achieve what you're looking.... Rob

=COUNTIF(C$42:C$65536,">="&$b$36)