Need help with Sumifs and or Combination...excel formula:

[pedie]

Hi, current formula:
'=SUMIFS($D$1:$D$27,$B$1:$B$27,"May",$C$1:$C$27,OR("FEC","ORANGE"))

I want to sum col D if col c either has "FEC" or "Orange"
and month is May in Col B.

Thanks for the Advice.

 

[barry houdini]

When the "OR"s apply to the same column it can be shortened, i.e.

=SUMPRODUCT(--(B1:B27="May"),(C1:C27="FEC")+(C1:C27="ORANGE"),(A1:A27="NY")+(A1:A27="LA")+(A1:A27="GA"),D1:D27)

 

[pedie]

Thanks Barry, thanks Marcelo, thanks alot guys
for your time and taking out time to explain how it works too...
Very helpful. Thanks again.

 

[Marcelo Branco]

When the "OR"s apply to the same column it can be shortened, i.e.

=SUMPRODUCT(--(B1:B27="May"),(C1:C27="FEC")+(C1:C27="ORANGE"),(A1:A27="NY")+(A1:A27="LA")+(A1:A27="GA"),D1:D27)

Yes, you are right.

Pedie, try this formula

M.

 

[pedie]

Okay Marcelo, thanks again!