# Count cells below or asbove value of another cell

1. ## Count cells below or asbove value of another cell

Hello, when I try to count cells above below the value of another cell, excel does not recognize my function , in fact it returns a false 0. How do I solve that?
Example: in C10 i write =COUNTIF(A1:A10,">=B10")
B10 could be 0.50, but i do not want to use the value, rather the reference to a specific cell.

2. ## Re: Count cells below or asbove value of another cell

If you only want to count cells and your range begins in row 1Perhaps =match(B10,a1:a100,0)-1

3. ## Re: Count cells below or asbove value of another cell

Sorry, I am inexperienced in excel and do not understand your example. I want to count the cells in a specific range that are greater/less in value than the value of another cell, instead of a fixed value. I want to do this for many different cells and values, so I need to do the exact same thing as the formula: =COUNTIF(range,">value") , but instead of that value i want to refer to the value of some cell in the worksheet. I hope i describe it properly
P.S. my range does not start in row 1 and it is not a fixed range

4. ## Re: Count cells below or asbove value of another cell

Perhaps =COUNTIF(A1:A10,">="&B10)

5. ## Re: Count cells below or asbove value of another cell

Yes, that helped me just fine. Thank you very much and wish you the best

6. ## Re: Count cells below or asbove value of another cell

You're welcome

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