Dec 03 2018 02:11 PM
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 trying to figure this out for quite some time!
Hopefully this is clear. But if not don't hesitate to contact me.
Thanks very much for your help.
Ray
Dec 03 2018 02:41 PM
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