array formular to add cell A1 across a number of sheets

[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

 

[Harald Staff]

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.

 

[davidbrowne17]

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??