Numbers Formula Help

Discussion in 'Mac Apps and Mac App Store' started by bafoote89, Jun 8, 2015.

  1. bafoote89 macrumors newbie

    Joined:
    Jun 8, 2015
    #1
    Im fairly new to numbers and Im creating my own numbers documents to keep track of my money matters (monthly budget, monthly outgo, total debt etc.)



    I used the Numbers Monthly Budget Template as a kind of reference for my own spreadsheet. Mine works just like the Monthly Budget Template but I added another page with my total debt. What Im trying to do is come up with a formula that subtracts the amount I put on my Outgo page from my Total Debt page. I would like it to work in the same way the Monthly Budget Template formulas work but subtraction instead of addition.


    So when I 'crunch my numbers' monthly and I pay $100 dollars to 'Debt One" I would like it to subtract from my total debt sheet
     

    Attached Files:

  2. ricosuave macrumors 6502

    ricosuave

    Joined:
    Mar 27, 2007
    Location:
    In front of my mac
  3. bafoote89 thread starter macrumors newbie

    Joined:
    Jun 8, 2015
    #3
  4. ricosuave macrumors 6502

    ricosuave

    Joined:
    Mar 27, 2007
    Location:
    In front of my mac
    #4
    You could send me the file without personal info on it and I'll take a look.
     
  5. notrack macrumors 6502

    Joined:
    Feb 19, 2012
    #5
    An approach at first sight... Debt One = initial amount minus SUMIF of "Debt One" in Outgo.
    If you use SUMIFS you can also set multiple criteria like description and category to be sure to sum the right entries.
     

Share This Page