• 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

  • Working Sheet.xlsx
    8.3 KB · Views: 5
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
 
Back
Top