• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to apply the COUNTIF function in the working attached in the post?

Dear Experts,

Attaching a small working sheet were there are some numbers entered in the X and Y column. I just want to count how many X numbers are below the Y numbers. The Ans i'm looking for is 3. How to do this using the COUNTIF function in excel. Do help me how to do it

Regards,
Sonjoe
 

Attachments

pecoflyer

Active Member
Your requirement is incomplete
Do you mean to compare row by row is D4>C4 and D5>C5, etc.. ?
If so =SUMPRODUCT(--(D4:D10>C4:C10)) returns 4, not 3
If you mean to count how many numbers in col D are larger than ANY number in col C it would be 5, I'm working on this second option
 
Your requirement is incomplete
Do you mean to compare row by row is D4>C4 and D5>C5, etc.. ?
If so =SUMPRODUCT(--(D4:D10>C4:C10)) returns 4, not 3
If you mean to count how many numbers in col D are larger than ANY number in col C it would be 5, I'm working on this second option
Thank You friend ....i just changed the formula and got the ans
 
Top