Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Function
I would like to use a SUMIF formula to add multiple columns. For instance, I
have a list of materials in a range from A6:A2403 and sales dollars for each material, by month, in columns H thru S. I want to be able to perform a SUMIF function to add Jan, Feb, and Mar sales dollars for any given material. Can anyone suggest any possible solutions? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Function
You could just sum the SUMIFs, ie: SUMIF(Jan col) + SUMIF(Feb col) +...
Alternatively, try something like this: =SUMPRODUCT((A6:A2403="x")*H6:S2403) to sum it at one go for cols H to S for material: x Above assumes that cols H to S contain no text data, only numbers Success? hit YES below -- Max Singapore --- "Traci P." wrote: I would like to use a SUMIF formula to add multiple columns. For instance, I have a list of materials in a range from A6:A2403 and sales dollars for each material, by month, in columns H thru S. I want to be able to perform a SUMIF function to add Jan, Feb, and Mar sales dollars for any given material. Can anyone suggest any possible solutions? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Function
Hi,
You may create a pivot table. Drag material to the row area and months (individually) to the data area. Now you may filter on any specific material -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Traci P." wrote in message ... I would like to use a SUMIF formula to add multiple columns. For instance, I have a list of materials in a range from A6:A2403 and sales dollars for each material, by month, in columns H thru S. I want to be able to perform a SUMIF function to add Jan, Feb, and Mar sales dollars for any given material. Can anyone suggest any possible solutions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to nest a left function within a sumif function? | Excel Worksheet Functions | |||
Using the TODAY() function in a SUMIF function | Excel Worksheet Functions | |||
SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
Can SUMIF function include AND function | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |