SUMIFS - Multiple Conditions

[DaleVacaro]

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)

 

[Joe4]

Enter this formula in H8 and copy down:

=SUMIFS(B$2:B$14,A$2:A$14,G8,C$2:C$14,">=1",C$2:C$14,"<=7",D$2:$D$14,"Orange",E$2:E$14,"Yes")

 

[DaleVacaro]

Hey Joe, sorry this is basic but u r a big help!!! Thank you so much!!

 

[Joe4]

You are welcome!

Hopefully it makes sense. The only real "tricky" part is the between 1 and 7 part. You actually need to split that into two conditions to do it.