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.
You may use
Explanation is here https://exceljet.net/formula/sumifs-with-multiple-criteria-and-or-logic