PaxSoprana
Level 1 (4 points)
iWork

Q: Running Cumulative Totals On Numbers

Hello All. I am new to Mac and have only recently begun dabbling with Mac Numbers.
I am currently trying to make a rudimentary spreadsheet for my Gas Payments with a small two column wide data set. One Column would represent every payment I make, and then I would like the second column to be a cumulative total of all the payments I have made to this point in the data set.

 

Screen Shot 2016-09-04 at 20.04.06.png

 

So as an example, I would like an equation that would add in the cumulative total in the right hand column, so that every time I added a figure under amount, it would automatically calculate the total to this point in the adjacent cell.


Is there anybody that can help me here?


Cheers!

Posted on Sep 4, 2016 12:17 PM

Close
PaxSoprana

Q: Running Cumulative Totals On Numbers

  • All replies
  • Helpful answers

  • by t quinn,Helpful

    t quinn t quinn Sep 4, 2016 2:52 PM in response to PaxSoprana
    Level 5 (4,930 points)
    Mac OS X
    Sep 4, 2016 2:52 PM in response to PaxSoprana

    Hi PaxSoprana,

     

    You can do something like this:

    Screen Shot 2016-09-04 at 2.03.42 PM.png

    C2 = 20 I copied/pasted this value from B2 just to ge things started.

    C3= B3+C2

    this formula is filled down usint the yellow fill haddle that appears when you hover over the selected cell.

     

    quinn

  • by t quinn,Helpful

    t quinn t quinn Sep 4, 2016 2:52 PM in response to t quinn
    Level 5 (4,930 points)
    Mac OS X
    Sep 4, 2016 2:52 PM in response to t quinn

    Oh, check out the budget template that is included with Numbers to see some other great tricks.

     

    q

  • by PaxSoprana,

    PaxSoprana PaxSoprana Sep 4, 2016 2:53 PM in response to t quinn
    Level 1 (4 points)
    iWork
    Sep 4, 2016 2:53 PM in response to t quinn

    Hi Quinn,
    You made that look so simple I feel a little embarrassed for having posted such a simple question.

     

    Anyway,

     

    Many thanks!

  • by t quinn,

    t quinn t quinn Sep 4, 2016 2:57 PM in response to PaxSoprana
    Level 5 (4,930 points)
    Mac OS X
    Sep 4, 2016 2:57 PM in response to PaxSoprana

    Hi PaxSoprano,

     

    Don't be embarrassed, we alI have to start somewhere. I am happy to help. Anything else for this question?

     

    quinn

  • by PaxSoprana,

    PaxSoprana PaxSoprana Sep 4, 2016 3:44 PM in response to t quinn
    Level 1 (4 points)
    iWork
    Sep 4, 2016 3:44 PM in response to t quinn

    Thank you!

    I think I'll be all right for the time being, but I was wondering whether there were any online tutorials or places I could go to get a bit of help so as to a quaint myself a better with numbers. Anything on the app store for example?

     

    Cheers

  • by t quinn,

    t quinn t quinn Sep 4, 2016 3:55 PM in response to PaxSoprana
    Level 5 (4,930 points)
    Mac OS X
    Sep 4, 2016 3:55 PM in response to PaxSoprana

    Hi Pax,

     

    When you place an "=" in an empty cell the formula inspector sidebar shows up and you can browse all the different functions Numbers offers along with the syntax and some examples. The Help menu can also be helpful.

     

    I want to restate the template suggestion I made earlier. Just poking around and seeing how they do things is a great way to learn. The personal budget, for instance, illustrates how to use SUMIF() to get category totals.

     

    I started reading this forum as a way to expand my understanding and it has been great fun.

     

    quinn