SUMIFS formula with 3 OR Conditions

T

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

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
 
T

Terri

Perfect! Thank you.

T. Valko said:
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





.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top