continuos summing

  • Thread starter Thread starter kwrohde
  • Start date Start date
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
 
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.
 
Back
Top