Forum Discussion

Copper Contributor

Dec 03, 2018

Excel SumIFS function

I have a problem when I try to add two or more items in the Excel SumIFS function. See the attached. The example where I am having a problem is the Function Formula in Yellow. I have been tryi...

SumIFS Function Practice.xlsx11 KB

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Dec 03, 2018

Hi Raymond,

You may use

=SUM(SUMIFS(A2:A10,B2:B10,{"Apples-Macintosh","Apples-Courtland"}))

Explanation is here https://exceljet.net/formula/sumifs-with-multiple-criteria-and-or-logic