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, ...
SergeiBaklan
Apr 15, 2019Diamond Contributor
Hi Ray,
With OR condition it shall be used as explained here https://exceljet.net/formula/sumifs-with-multiple-criteria-and-or-logic