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?

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?

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?