SUMIF function with mutiple SUM_RANGE values

**shep85** · 09-01-2010, 12:55 PM

I have created a program to track rebar for a project. I created a lookup function to refrence information regarding the rebar. i have multiple rebar types in each section, and now I am trying to sum the amount of each type of rebar for each stage of the project. I tried to do use a SUMIF function as a tool but can not seem to get it to work. Here is a section of how the sheet is set up,

I have each stage broken down into seperate sections as shown above, with all three stages on a seperate tab. The final tab I want to total all of the similar bars for each stage, the total h60 (E) bars for stage I for example. i am using =SUMIF('Stage I'!A:A,"=Totals!B5",'Stage I'!F6:F7) as my command. It works for a single SUM_RANGE value, but when I insert 'Stage I'!F6:F7,'Stage I'!F11:F14, etc in the SUM_RANGE value then I get a # VALUE! error. Can anyone help me sum the total number of bars for multiple sections?

**antoka05** · 09-01-2010, 01:32 PM

I think in SumIf function the rows specified as first parameter and third parameter must be the same, for example try to write:
=SUMIF('Stage I'!A6:A7,"=Totals!B5",'Stage I'!F6:F7)
and so on.

Regards,
Antonio

**shep85** · 09-01-2010, 01:55 PM

Thanks Antonio,
yes that does work for a single SUM_RANGE value, but what it still wont work for multiple SUM_RANGE values.

any thoughts?

**shg** · 09-01-2010, 02:13 PM

You would do yourself a big favor if you changed your table to a database layout: One header row with a column for each field (substructure, bar, size, ...), and no blanks. Then all your formulas, or a pivot table, are easy.