Sheet 1 ....Sheet 10 Total

[kuzna26]

Please guys

is there way in cell to have the to of 10 sheet in One
If I take A1 in sheet + A1 sheet 2 ......... A1Sheet 10 and have the in Sheet TOTAL in D2

the question here is each day I will copy sheet 1 and make it sheet2 and on second day I will copy sheet 2 to
Sheet 3

Will Sheet TOTAL will count the total as I add from one sheet to another one ??????


Thanks

[benishiryo]

hi kuzna. it would be something like:
=SUM(Sheet1:Sheet10!A1)

it's called 3-D referencing. read about it in here:
http://office.microsoft.com/en-sg/ex...010102346.aspx

[:) Sixthsense :)]

In D2 Cell

=SUM(Sheet1:Sheet10!A1)

[Pepe Le Mokko]

As your number of sheets seem to be changing, perhaps create a sheet called "Start" which you place before all the others and a sheet called "End" after all the sheets. ( sheet names are not relevant)

Then use =SUM(Start:End!A1) as the esteemed Guru's suggested.You can then add any number of sheets between those two, the formula will work.
(I think you can also hide the Start and End Sheet)

[FDibbins]

To add to Pepe's suggestion, you can also remove sheets just by dragging then outside of the start/end sheets

[kuzna26]

in d2 cell

=sum(sheet1:sheet10!a1)

i have usde the formula but it doesn't work could please exemplify in the attached sheet

thanks

[Jonmo1]

4 issues.
Here's the formula you said you used
=SUM(one!:Ten!A1)

1. There is no sheet named Ten in the book you posted
2. You don't use an ! after the first sheet, only after the 2nd.
3. You don't have a number in A1 of the sheet named One (it's the letter S)
4. The sheet named One is actually named "One " <- notice the space at the end.

So
Rename "One " to "One"
Create a new sheet named "Ten"
Make shere the Sheet Ten is placed to the RIGHT of Sheet One
Put NUMBERS in A1 of those sheets.
Then use this formula on the Total Sheet

=SUM(One:Ten!A1)


Hope that helps.