|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 6th, 2008, 08:17 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif with 2 ranges and multiple criteria
I need help figuring out how to sum a range if I have multiple criteria in 2
separate columns not next to one another. This is what I have but it's not working: sumif('ALC 2007 Q4'!I4:I346 or 'ALC 2007 Q4'!C4:C346, "Industry-all" or "product 1" or "product 2", 'ALC 2007 Q4'!F4:F346) 
|
|
#2
November 6th, 2008, 08:37 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumif with 2 ranges and multiple criteria
=SUMPRODUCT(('ALC 2007 Q4'!I4:I346={"Industry-all","Product 1","Product
2"})*'ALC 2007 Q4'!F4:F346) "AC" wrote: I need help figuring out how to sum a range if I have multiple criteria in 2 separate columns not next to one another. This is what I have but it's not working: sumif('ALC 2007 Q4'!I4:I346 or 'ALC 2007 Q4'!C4:C346, "Industry-all" or "product 1" or "product 2", 'ALC 2007 Q4'!F4:F346)
|
|
#3
November 7th, 2008, 03:26 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumif with 2 ranges and multiple criteria
If a criteria is in both ranges should it calculate as 2x or 1x. For
example: C4 = Industry-all I4 = product 2 F4 = 10 Should the result be 10 or 20? -- Biff Microsoft Excel MVP "AC" wrote in message ... I need help figuring out how to sum a range if I have multiple criteria in 2 separate columns not next to one another. This is what I have but it's not working: sumif('ALC 2007 Q4'!I4:I346 or 'ALC 2007 Q4'!C4:C346, "Industry-all" or "product 1" or "product 2", 'ALC 2007 Q4'!F4:F346)
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
