SUMIFS - Multiple Conditions

[alreadybeen23]

Hi Team,

May you help me with below? Below are the condition.

Sample result is highlighted in yellow:

1. Sum the values of Money (Column B)
2. Include Stage 1-7 only (Column C)
3. Include color orange only (Column D)
4. Yes only (Column E)


excell helplplplp.jpg

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

[Pete_UK]

Try this formula in H8:

=SUMIFS(B:B,A:A,G8,C:C,">0",C:C,"<=7",D:D,"Orange",E:E,"Yes")

then copy down as required.

Hope this helps.

Pete