Running Cumulative Totals On Numbers

Question

Level 1

8 points

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.

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

Reply

Answer 1

Best reply

t quinn

Level 5

7,042 points

Sep 4, 2016 2:52 PM in response to PaxSoprana

Hi PaxSoprana,

You can do something like this:

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

Reply

Answer 2

t quinn

Level 5

7,042 points

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

Reply

Answer 3

PaxSoprana Author

Level 1

8 points

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!

Reply

Answer 4

t quinn

Level 5

7,042 points

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

Reply

Answer 5

PaxSoprana Author

Level 1

8 points

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

Reply

Answer 6

t quinn

Level 5

7,042 points

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

Reply