• 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.

Is it possible to apply sumif and countif in a same cell?

fahadferoz

fahadferoz

Member
Hi

In the attached excel sheet on summary tab I am trying to add up the total amount due in the TSO Zamir's outlets where last bill difference is more than 30 days (in cell J5). I have managed to set formulas for I5. But can't figure out how to use sumif and countif formula in the same cell (in the case of J5).

The problem is: I can't give a formula where the value I need is the total amount of due of Zamir's outlets where the last bill difference is more than 30 days.

Would be great if somebody help me.

The detail excel sheet is attached.

Thanks in advance.
 

Attachments

  • Outlet Wise Due Statement.xlsx
    20.5 KB · Views: 5
Hello Fahad,
Good day and welcome to the forum...

You use the SUMIFS in J5:

=SUMIFS('OUTLET WISE DUE'!$F$3:$F$78,'OUTLET WISE DUE'!$C$3:$C$78,D5,'OUTLET WISE DUE'!$J$3:$J$78,">30")
Copy down.

Is it possible to apply sumif and countif in a same cell?
Click to expand...
I didn't understood :(

Regards,
 
Hi Khalid,

It Worked. I was really struggling with it.

Your help meant a lot to me. Chandoo is indeed the best excel site ever!

Thanks Again!
 
You must log in or register to reply here.
Back
Top