| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIFS formula using dates and text as criteria | Excel Discussion (Misc queries) | |||
| Sumifs formula in Excel 2007 | Excel Discussion (Misc queries) | |||
| Convert SUMIFS formula from 2007 to 2003 | Excel Discussion (Misc queries) | |||
| sumifs formula in excel 2007 | Excel Discussion (Misc queries) | |||
| SUMIFS Formula Problem | Excel Discussion (Misc queries) | |||
Linear Mode
