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