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?