SUMIF Function
in [Functions]
|
From: Traci P. on 8 Apr 2010 18:46 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?
From: Max on 8 Apr 2010 19:12 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? >
From: Ashish Mathur on 13 Apr 2010 19:56 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." <TraciP(a)discussions.microsoft.com> wrote in message news:87856203-970E-4CC2-9FE3-09E0790C820C(a)microsoft.com... > 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? >
|
Pages: 1 Prev: how to count#cells w/= value in other column and not count bla Next: How to count merged cells |