Excel function Sumifs

Copper Contributor

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

@Raymond Sanner 

Hi Ray,

 

With OR condition it shall be used as explained here https://exceljet.net/formula/sumifs-with-multiple-criteria-and-or-logic