Albion

How is the summing done?

What does the formula look like?

If 3D as Don suggests, make sure that the same sheets are always included in
the 3D.

One wy to ensure this is to insert a dummy sheet and beginning. Name it
Start.

Insert a dummy sheet just before the Summary sheet. Name it End.

3D formula on Summary sheet =Start:End!A1

Moving sheets around between Start and End should not pose a problem.


Gord Dibben Excel MVP

On Thu, 17 Feb 2005 20:47:46 -0300, "Albion" wrote:

Nope, it doesn´t have to do with ranges... he´s summing up the same cell
(A1) in each worksheet.

Regards,
Albion - Argentina
"Don Guillett" escribió en el mensaje
...
if you have a formula =sum(sheet1:sheet10!a1) then just make sure all
additions are made within the range.

--
Don Guillett
SalesAid Software

"Drakkip" wrote in message
...
I am using a workbook to manage a database. The last page of the
workbook
summarizes the data base by adding the same cell of each worksheet.

When I move any of the sheets in the workbook it appears to no longer
summarize the data correctly on my last summary sheet. I have to go to
my
formulas, and copy and paste them.

Although I am not changing the content of any of the formulas in order
for
it to properly calculate any new data inputted to the balance of any of
the
worksheets will not be incorporated into the calculations.

Is there a solution other than to re-paste all the formulas on my
summary
sheet?