Spreadsheet summary automatically referrences totals of worksheets
Hi,
It sounds like you are asking - If you add a sheet can the Summary sheet
pick of the total cell from the new sheet.
If that is the case, maybe -
1. if the total cell is in same cell on all sheets
2. if you can insert the new sheet between the first and last sheets that
are being summed
3. if there are no sheets between the first an last sheet which you don't
want summed
If those condtions are met, then suppose the first sheet is named First and
the last sheet is named Last, and the total cell is in T20 on all the sheets,
then you can use a formula of the following type
=SUM(First:Last!T20)
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"Hulqscout" wrote:
I have a spreadsheet summary sheet that references change order totals from
multiple worksheets. Each row on the spreadsheet summary references a
'subtotal' cell on sucessive change order worksheets. The total cell is the
same in each sheet. As I copy additional worksheets, is there a way to
automatically reference the total with out manually referencing the worksheet
total to the summary cell.
|