Forum Discussion

Soso22190's avatar
Soso22190
Copper Contributor
Feb 15, 2024

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...
  • HansVogelaar's avatar
    Feb 15, 2024

    Soso22190 

    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.

Resources