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?
marcvanderpeet12 Syntax = COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)
If Your cell E3 has text Cheap .. =COUNTIFS(Table1[Fruit],E2,Table1[Price],E3)