SUMIF Function

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

 

[Max]

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

 

[Ashish Mathur]

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