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





.
Click to expand...
 

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

Similar Threads

Formula Help 2
SUMIFS help 3
SUMIFS with an OR criteria 8
Help with lots of formulas 3
SumIf or SumIfs or something else? 2
Multiples conditions in an array 3
Mutiple conditions formula to assign segmentations and coverage 0
Can SUMIFS use the OR function? 7

Top