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!! 😄