array formular to add cell A1 across a number of sheets

  • Thread starter Thread starter davidbrowne17
  • Start date Start date
D

davidbrowne17

any idears.

is there a simple way to add the contents of a cell that is duplicated
across a number of sheets.

i have a workbook with 100 sheets on it and want to be able to total
the contents a cell A1, which is repeted across sheets 2-100

Ta

dave
 
Hi Dave

=SUM(Sheet2:Sheet100!A1)
no array entry needed. But it sums by sheet placement index, not by sheet
name, so do not move sheets out of the initial order.
 
I have tried your suggestion and entered;

=SUM(Sheet4:Sheet100!D8)

but after this formular has been entered it is changed to look like
this??

=SUM(Sheet4:'3:[Sheet100]Sheet100'!D8)

and so then does not work??
 
Back
Top