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...
Formulas & Functions
Need Help
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Apr 09, 2017

Hi

 

Try this:

 

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

 

Resources