# countif + "greater than" "cell value" 2

1. ## 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

2. ## Re: countif + "greater than" "cell value" 2

Hi vonPalm,

Try:

``Please Login or Register  to view this content.``
using "Ctrl+Shift+Enter" to enter the formula.

Cheers,

3. ## Re: countif + "greater than" "cell value" 2

You can do that like this

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

4. ## Re: countif + "greater than" "cell value" 2

Hi!
Yipiie it's working =)!! Both methods work fine, thanks a million!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1