Forum Discussion

Excel's avatar
Excel
Iron Contributor
Mar 12, 2022
Solved

Dynamic Substract

Hello Everyone,  I would like the number in cell C2 to decrease every time I add a number to the whole of the column C. I would like for any number I enter into the B column to be subtracted automat...
Formulas and Functions
  • Gaurav675's avatar
    Gaurav675
    Mar 12, 2022

    Excel 

     

    Use this formula =$C$2-SUM($B$3:B3). Also, I have attached screenshot for reference.

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Mar 12, 2022

Excel Not sure what you mean but perhaps like in the picture below??

 

Excel's avatar
Excel
Iron Contributor
Mar 12, 2022
It helps.
Thank you so much sir.

Resources