sum across range of sheets for a cost code
 

I'm trying to create a summary sheet at the end of a workbook that will
automatically total the amount spent from a specific cost code.

My first sheet is "template" and my last sheet is "Totals", cell O32
contains the total spent and cell H38 contains the cost code of each oder.
Each time an order is made, the template sheet is copied and renamed
according to vendor and date and placed in front of the "Totals" sheet.

I've tried:
=SUMIF(template:Totals!H38,"4960.114.44114",templa te:Totals!O32)

Does anyone have suggestions.

sum across range of sheets for a cost code
 

Where you define a name ms= and modify as needed. Or make a list in a
column.
={"Sheet1","Sheet2","Sheet3"}

=SUMPRODUCT(SUMIF(INDIRECT(ms&"!h38"),"xx",INDIREC T(ms&"!o32")))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"monkeydoom" wrote in message
...
I'm trying to create a summary sheet at the end of a workbook that will
automatically total the amount spent from a specific cost code.

My first sheet is "template" and my last sheet is "Totals", cell O32
contains the total spent and cell H38 contains the cost code of each oder.
Each time an order is made, the template sheet is copied and renamed
according to vendor and date and placed in front of the "Totals" sheet.

I've tried:
=SUMIF(template:Totals!H38,"4960.114.44114",templa te:Totals!O32)

Does anyone have suggestions.