Spreadsheet summary automatically referrences totals of worksheets
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. |
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. |
Spreadsheet summary automatically referrences totals of worksh
Your close. I am not totaling the change orders just showing on the
succesive row. For example: the first row of the summary sheet lists the total of CO1, the second row lists the total from CO2, the third row list the total from CO3, etc. The summary sheet has a grand total of each row. "Shane Devenshire" wrote: 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. |
All times are GMT +1. The time now is 07:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com