Forum Discussion
piney29887
Apr 09, 2017Copper Contributor
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_LewinSilver Contributor
Hi
Try this:
=SUM(SUMIFS(T4:T30,A4:A30,"SUN",I4:I30,{"X";"Y";"Z"},Q4:Q30,"D"))