Forum Discussion
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 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
1 Reply
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
