continuos summing

K

kwrohde

i have a workbook with many worksheets. all the work sheets ar
identicle in format except for the last one. The last work sheet i
used to sum values from the rest of the worksheets. The total sum o
the last worksheet comes from the same cell on the rest of th
worksheets. I add additional worksheets to the workbook each day, an
i want the sum to update automatically without having to phisicall
change the formula. Perhaps using some sort of "all worksheets
function. If you have any ideas let me know
 
J

J.E. McGimpsey

Create two blank sheets and name them something like "First" and "Last".
put "First at the left of your first sheet and "Last" at the right of
your last sheet to sum. Then change your formulae to read, e.g.,

=SUM(First:Last!A1)

note that XL sums by position, so subsequent sheets must be inserted
between First and Last to be summed.
 
Top