SUMIF Function

  • Thread starter Thread starter Traci P.
  • Start date Start date
T

Traci P.

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?
 
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
 
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
 
Back
Top