Forum Discussion
Solved
Formula to add numbers from a specific cell in all my worksheets
Good morning, I have an Excel spreadsheet with many worksheets. The last worksheet is a recap. In the recap worksheet I have a cell (for sake of argument E5) that needs to capture the overal...
Insert a blank worksheet before the first one you want to want to subtract from D5, and name it First.
Insert a blank worksheet after the last one you want to want to subtract from D5, and name it Last.
Change the formula to
=D5-SUM(First:Last!B13)
When you want to add a new sheet, insert it between First and Last. It will automatically be included in the formula result.
Insert a blank worksheet before the first one you want to want to subtract from D5, and name it First.
Insert a blank worksheet after the last one you want to want to subtract from D5, and name it Last.
Change the formula to
=D5-SUM(First:Last!B13)
When you want to add a new sheet, insert it between First and Last. It will automatically be included in the formula result.
- OMG OMG OMG!!! It works!!! Thank you so so so so so so so much!! 😄
