countif + "greater than" "cell value" 2

Hi all, I have a very simple problem but I have spent several hours trying to find the answer. I have really tried to search for the answer but no matter how I formulate my search criteria I always end up with a thousand irrelevant links.

Enough wining =)! I just wanted to explain why I start a new thread instead of searching existing threads.

So.. I want to use COUNTIF function to count the number of cells in a range where the value of the cell is greater than the value of a referance cell. For example: =COUNTIF(A4:A10;>B6), exept this is not working.

It's easy if I would compare it to a number but now I want to compare the value of a cell with the value of another cell.

Thanks

Hi vonPalm,

Try:

Please Login or Register  to view this content.

using "Ctrl+Shift+Enter" to enter the formula.

Cheers,

You can do that like this

=COUNTIF(A4:A10;">"&B6)