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

Sumif that takes multiple values into account

Dear all,

I am looking for an sumif formula that takes into account multiple values. So in the case of the attachment - how can I write an sumif statement that count the cases where the condition apple and cheap is met?
 

Attachments

  • example.xlsx
    10 KB · Views: 5
marcvanderpeet12
Syntax
= COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)
If Your cell E3 has text Cheap ..
=COUNTIFS(Table1[Fruit],E2,Table1[Price],E3)
 
Back
Top