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