Forum Discussion
Need help with a formula to carry result to another page in excel
To help you with carrying forward a total from a sub-page to another page in Excel, you can use a simple formula. Assuming you want to reference a cell from the sub-page to the main page, here's an example:
Let's say your total in the sub-page is in cell A1. On the main page, you want to carry forward this total to cell B1. In cell B1 on the main page, you can use the following formula:
='Sub-Page'!A1
Replace 'Sub-Page' with the actual name of your sub-page.
This formula simply references the value in cell A1 of the sub-page and displays it in cell B1 of the main page. Adjust the cell references based on your actual layout.
If you want to carry forward a total from multiple cells, you can use formulas like SUM, depending on your specific scenario. Feel free to provide more details if you need a more tailored solution! The text and steps were edited with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and Like it!
This will help all forum participants.