Subtraction Formula


Hi folks,

I have a Debt total in a cell on my budget spreadsheet (e.g. 7000); I have a row of payments by month (e.g. 160). I want to subtract each new cell of payment of 160 from the total cell of 7000. I want to visibly see the reduction on the 7000 debt cell when each new month of payment is added. Is there a formula for this?




  • Dale Murphy
    Dale Murphy ✭✭✭✭✭✭

    @nicole.turner Do you want to (continue to) see the original $7,000 somewhere? Or will it be gone once payments start? Is the $160 the monthly payment, meaning it will appear on subsequent rows? Something like this?

    Is that the presentation you want?


  • nicole.turner

    Yes, that's exactly it! How?! :-D

  • DHarris
    DHarris ✭✭
    edited 12/21/22

    Create your sheet using above?

    In the "Outstanding" column, use this formula and you should be good to go.

    =Original1 - SUM(Original4:Original8) -- put this in the column/row where you want the results to appear.

    Original1 = the the column/row showing original amount owned ( I assume) $7000

    Original4 = the column/row where the first payment is recorded

    Original8 = the column/row where the last recorded payment is made

    Hopefully that helps you to understand and also gets you going along.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!