Forum Discussion
Summary Sheet Problems
So, I have an Excel 365 workbook with multiple sheets. I use it to track monies banked into a single bank account but for multiple purposes (rent, comms, clothing etc). Each sheet has a balance colum...
Let say you have Jan, Feb and March sheets with the following values in cells A1: 50, 60, 30 formatted in Excel Table using
In your Summary sheet, excuse: =SUM(
2. Click on cell A1 in Jan sheet
3. Hold down the SHIFT key and click on March sheet
4. Click Enter
All the values in cells A1 across the 3 sheets will be summed and delivered in cell A1 of your Summary sheet in structured reference.
So when new values are added to the Tables in any of the three sheets, the table grows.. And this helps you to reference more values across different sheets than using only = sign
In your Summary sheet, excuse: =SUM(
2. Click on cell A1 in Jan sheet
3. Hold down the SHIFT key and click on March sheet
4. Click Enter
All the values in cells A1 across the 3 sheets will be summed and delivered in cell A1 of your Summary sheet in structured reference.
So when new values are added to the Tables in any of the three sheets, the table grows.. And this helps you to reference more values across different sheets than using only = sign