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
Bookmarks