Totaling Across Multiple Worksheets

[coreymartin]

In my workbook, I have varying numbers of worksheets, each with
numerical values in the A3 field. I then have a sheet which totals up
all the A3 values of each worksheet. My problem is that the number of
worksheets varies, and when I add/remove worksheets from a workbook, I
have to redo the sum function on the total sheet.

Can I make my total sheet automatically compute the A3 cells of all
other worksheets, no matter how many there are?

This may not have a solution other than manually doing it everytime,
but I'd very much appreciate any help.

Thanks!

 

[Stephen]

In my workbook, I have varying numbers of worksheets, each with
numerical values in the A3 field. I then have a sheet which totals up
all the A3 values of each worksheet. My problem is that the number of
worksheets varies, and when I add/remove worksheets from a workbook, I
have to redo the sum function on the total sheet.

Can I make my total sheet automatically compute the A3 cells of all
other worksheets, no matter how many there are?

This may not have a solution other than manually doing it everytime,
but I'd very much appreciate any help.

Thanks!

You can use a couple of extra blank worksheets - let's call them First and
Last - that can be hidden if you wish. You write your formula to refer to
the range First!A3:Last!A3. All the worksheets between them contribute to
the total, no matter how many there are. Simply add new ones anywhere in
between them and/or delete any you don't want.

 

[Peo Sjoblom]

Insert 2 dummys sheets that are empty and then insert all new sheets
in-between

=SUM(first:last!A3)

that way you always will include any new sheets