Forum Discussion
Raymond Sanner
Apr 15, 2019Copper Contributor
Excel function Sumifs
Can you tell me why the formula in color ORANGE gives me the result of 0. Should be 13
I think SumIfs function should give me the answer - let me know how to correct.
See Attached.
Thanks,
Ray
1 Reply
- SergeiBaklanDiamond Contributor
Hi Ray,
With OR condition it shall be used as explained here https://exceljet.net/formula/sumifs-with-multiple-criteria-and-or-logic