Forum Discussion

piney29887's avatar
piney29887
Copper Contributor
Apr 09, 2017

SUMIFS using OR

I currently have the following formulas in cells N1 thru N3:
=SUMIFS(T4:T30, A4:A30,"SUN", I4:I30,"X", Q4:Q30,"D")
=SUMIFS(T4:T30, A4:A30,"SUN", I4:I30,"Y", Q4:Q30,"D")
=SUMIFS(T4:T30, A4:A30,"SUN", I4:I30,"Z", Q4:Q30,"D")
and in cell N4 I have:
=SUM(N1:N3)

which gives me a result of 8.00, which is correct
When I've tried

=SUMIFS(T4:T30, A4:A30,"SUN", I4:I30,OR("X","Y","Z"), Q4:Q30,"D")

there's no apparent error, but the result is 0.

Suggestions?

 
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    Hi

     

    Try this:

     

    =SUM(SUMIFS(T4:T30,A4:A30,"SUN",I4:I30,{"X";"Y";"Z"},Q4:Q30,"D"))

     

Resources