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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|