SUMIFS formula with 3 OR Conditions
 

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$10 00,"Mar",Goldmine!$K$2:$K$1000,"DAWNV*",Goldmine!$ D$2:$D$1000,{"BRD","SPG","ADR"}))/1000

SUMIFS formula with 3 OR Conditions
 

Try it like this...

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

--
Biff
Microsoft Excel MVP


"Terri" wrote in message
...
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$10 00,"Mar",Goldmine!$K$2:$K$1000,"DAWNV*",Goldmine!$ D$2:$D$1000,{"BRD","SPG","ADR"}))/1000

SUMIFS formula with 3 OR Conditions
 

Perfect! Thank you.

"T. Valko" wrote:

Try it like this...

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

--
Biff
Microsoft Excel MVP


"Terri" wrote in message
...
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$10 00,"Mar",Goldmine!$K$2:$K$1000,"DAWNV*",Goldmine!$ D$2:$D$1000,{"BRD","SPG","ADR"}))/1000


.

SUMIFS formula with 3 OR Conditions
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Terri" wrote in message
...
Perfect! Thank you.

"T. Valko" wrote:

Try it like this...

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

--
Biff
Microsoft Excel MVP


"Terri" wrote in message
...
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$10 00,"Mar",Goldmine!$K$2:$K$1000,"DAWNV*",Goldmine!$ D$2:$D$1000,{"BRD","SPG","ADR"}))/1000


.