total in a frontsheet

[Bo]

Im having 20 subsheets that are build the same way.

Is there a function to sum cells for all 20 subsheets
into the frontsheet ?

 

[Paul]

Im having 20 subsheets that are build the same way.

Is there a function to sum cells for all 20 subsheets
into the frontsheet ?

Something along these lines will work:
=SUM(Sheet1:Sheet20!A1)

 

[JON JON]

Bo,

Sounds like it is better to use Data|Consolidate. This is in help file
"about consolidating data."

Consolidating by position

Consolidate by position when the data in all source areas is arranged in
identical order and location; for example, if you have data from a series of
worksheets that were created from the same template, you can consolidate the
data by position.

You can set up the consolidation to update automatically when the source
data changes, but you won't be able to change which cells and ranges are
included in the consolidation. Or you can update the consolidation manually,
allowing you to change the included cells and ranges.



Regards,

Jon-jon