On Sheet13, enter the following formula in B2 and copy down:

=SUMPRODUCT(SUMIF(INDIRECT("'Sheet"&ROW(INDIRECT(" 1:12"))&"'!A2:A100"),A2,INDIRECT("'Sheet"&ROW(INDI RECT("1:12"))&"'!B2:B100")))

If you decide to change the sheet names, you could use the following
formula instead...

=SUMPRODUCT(SUMIF(INDIRECT("'"&$D$2:$D$13&"'!A2:A1 00"),A2,INDIRECT("'"&$D$2:$D$13&"'!B2:B100")))

...where $D$2:$D$13 contains the sheet names. Adjust the range
(B2:B100) accordingly.

Hope this helps!

Steve Wrote:
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


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=318889