Sumif that takes multiple values into account

[marcvanderpeet12]

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?

 

[vletm]

marcvanderpeet12
Syntax
= COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)
If Your cell E3 has text Cheap ..
=COUNTIFS(Table1[Fruit],E2,Table1[Price],E3)