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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

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.

--
HTH. Best wishes Harald
Followup to newsgroup only please

"davidbrowne17" <(E-Mail Removed)> skrev i melding
news:(E-Mail Removed)...
>
> 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
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
>

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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/