SUMIF Function

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

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
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top