| Home |
| Search |
| Today's Posts |
|
#1
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
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
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Awkward sumif/sumproduct with three criteria over two ranges | Excel Worksheet Functions | |||
| SUMIF Multiple Criteria in different ranges. | Excel Worksheet Functions | |||
| Sumif with 2 ranges & 2 criteria | Excel Worksheet Functions | |||
| Calculate a SUMIF if criteria is between 2 date ranges | Excel Worksheet Functions | |||
| SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
Linear Mode
