Inventory sheets

[Philippe L. Balmanno]

I have a situation where I have a workbook with worksheets. Each work sheet
is exactly identical in format and I want to tally exactly the same cell in
each worksheet. Example: workbook X | sheets A, B, C, .... Z | sum cell A5.
My delema is that I don't want to write a very long formula with
=sum(A!A5+B!A5... for all the sheets. I was thinking if I put the names of
the sheets in an array if there was a way to sum(array A5? Or how would I
do it. There is about 50 sums to be done on the summary sheet. TIA

 

[Gord Dibben]

Phillipe

Easily done on a master sheet.

=SUM(A:Z!A5)

Gord Dibben Excel MVP

 

[Domenic]

=SUM(SheetA:SheetZ!A5)

Hope this helps!

 

[Patti]

Will this work?

=sum('SheetA:SheetZ'!A5)

 

[Philippe L. Balmanno]

Perfect, Thank you.

=SUM(SheetA:SheetZ!A5)

Hope this helps!