SUMIFS formula with 3 OR Conditions

[Terri]

I have a 2007 spreadsheet that is looking to another worksheet Column F for
the month of March, Column K for salesperson Dawn, and Column D for a product
code, once all these conditions have been met it is totalling those sales
values in column E. The problem is Column D. I want it to find BRD, or, SPG,
or ADR. The formula I have below is only finding BRD, it's not recognizing
the other 2 product options?

=(SUMIFS(Goldmine!$E$2:$E$1000,Goldmine!$F$2:$F$1000,"Mar",Goldmine!$K$2:$K$1000,"DAWNV*",Goldmine!$D$2:$D$1000,{"BRD","SPG","ADR"}))/1000

 

[T. Valko]

Try it like this...

=SUM(SUMIFS(Goldmine!$E$2:$E$1000,Goldmine!$F$2:$F$1000,"Mar",Goldmine!$K$2:$K$1000,"DAWNV*",Goldmine!$D$2:$D$1000,{"BRD","SPG","ADR"}))/1000

 

[Terri]

Perfect! Thank you.

Try it like this...

=SUM(SUMIFS(Goldmine!$E$2:$E$1000,Goldmine!$F$2:$F$1000,"Mar",Goldmine!$K$2:$K$1000,"DAWNV*",Goldmine!$D$2:$D$1000,{"BRD","SPG","ADR"}))/1000

--
Biff
Microsoft Excel MVP





.

 

[T. Valko]

You're welcome. Thanks for the feedback!