Forum Discussion
Solved
Creating a summary sheet in a workbook
I have about a dozen worksheets (within a workbook) with data that accumulates into a summary on each page. I need to create a summary page that brings in the data from the individual summaries to s...
- Alright... If all sheets you want to summarise the total have the same structure including the Summary sheet, then you can use Group Sheet technique.
For example, you have 50,30, 45 in cells A1 of sheet1 sheet2 and sheet3 respectively.. In sheet4 which is the summary sheet, select cell A1 and type in =SUM(
Then, click on the value in cell A1 of sheet1 and hold down the SHIFT key. Then select sheet3 (this will group all the sheet1 to sheet3 together)
Finally, click Enter.
All the values in all the three sheets will be summed and delivered in cell A1 of Sheet4 which is the summary sheet!
Alright... If all sheets you want to summarise the total have the same structure including the Summary sheet, then you can use Group Sheet technique.
For example, you have 50,30, 45 in cells A1 of sheet1 sheet2 and sheet3 respectively.. In sheet4 which is the summary sheet, select cell A1 and type in =SUM(
Then, click on the value in cell A1 of sheet1 and hold down the SHIFT key. Then select sheet3 (this will group all the sheet1 to sheet3 together)
Finally, click Enter.
All the values in all the three sheets will be summed and delivered in cell A1 of Sheet4 which is the summary sheet!
For example, you have 50,30, 45 in cells A1 of sheet1 sheet2 and sheet3 respectively.. In sheet4 which is the summary sheet, select cell A1 and type in =SUM(
Then, click on the value in cell A1 of sheet1 and hold down the SHIFT key. Then select sheet3 (this will group all the sheet1 to sheet3 together)
Finally, click Enter.
All the values in all the three sheets will be summed and delivered in cell A1 of Sheet4 which is the summary sheet!