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?
