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...
  • Gaurav675's avatar
    Mar 12, 2022

    Excel 

     

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

     

Resources