Hi
try
=SUMPRODUCT(SUMIF(INDIRECT("'Sheet" &ROW(INDIRECT("1:12")) &
"'!A1:A100"),A1,INDIRECT("'Sheet" &ROW(INDIRECT("1:12")) &
"'!B1:B100")))

--
Regards
Frank Kabel
Frankfurt, Germany

"Steve" schrieb im Newsbeitrag
om...
Hi Frank,

Thank you for your reply. Currently, the sheets are just named
"sheet1" through "sheet13". Sheets One through Twelve represent the
months and 13 is the "totals" sheet. The machine name is located in
Column A. The time Value for the machine is located in Column B.
Sheets One through Twelve would basically read:

Column A ColumnB

Row1 Machine 1 35
Row2 Machine 2 17
etc..

Sheet 13 Would show the name in Column A and the total number of
hours
in Column B.

Thanks!!

Steve Kaufer

"Frank Kabel" wrote in message
...
Hi
could you provide some more info:
- how are the sheets named
- there's the machine name located
- there#s the value to sum located on each sheet

--
Regards
Frank Kabel
Frankfurt, Germany

"Steve" schrieb im Newsbeitrag
om...
Hello,

I am trying to create a sheet which totals numbers from column B
on
one final sheet. What we have is a bunch of machines which we
want
to
track the hours of on a monthly basis and on a "total use" basis.
I
created a workbook with 13 sheets, one for each month and then a
"total" sheet. Column A will list the machine name (will be the
same
name and order on each sheet) and column B will list the hours
for
that month. I need the final sheet to show the machine name from
Column A and the sum of all the COlumn B info (total hours) for
each
month. I'm struggling with the 3D options and other table
functions.
I really appreciate any direction someone may be able to give me
:)
Thank god for Deja!!

Steve