View Single Post
  #1   Report Post  
Renata Lemos
 
Posts: n/a
Default COUNTIF > CELL VALUE

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