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 show the accumulated total for all the worksheets. I hope that makes sense. I appreciate any guidance anyone can provide.
- 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!
6 Replies
There's potentially several options depending on the arrangement of the data. It's difficult to recommend a solution without a sample.
- 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! - Hello,
Instead of having dozens of sheets that has the same structure in a workbook, it will be fantastic to have all the data from the several sheets into a single sheet. Then you will a Summary sheet to use the Excel's functionality- Thank you but that doesn't meet my needs. I need the tabs(worksheets) and I need a summary sheet. I just need the formula that gathers the info from all the worksheets.
