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

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

"Renata Lemos" <Renata wrote in message
...
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

Renata,

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

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


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