Numbers calculations = cumulative total

Hi Carol,

Can we take a look at your document? If you are OK with that:

• make a copy of your document;
• remove all personal or sensitive information (you could insert made-up data);
• upload the copy to a public sharing website such as Dropbox: https://www.dropbox.com;
• copy the link to the document and paste it here in a reply.

We will reply to you in this forum, Numbers for Mac.

Regards,

Ian.

Rarely do you need to type the column letter or row number. Select cells and let Numbers do that for you.

For example, start with this:

Type = to call up the formula editor and select B1:B2.

Click the address token and uncheck Preserve Row under End:

Type - SUM at the end of the formula click the SUM in the bar that appears:

Click the value token and select cells C1:C2, giving you this:

Click the address token and uncheck sPreserve Row under End:

Click the check or hit return to accept the formula, select the cell and hover over the bottom edge of the cell and drag the yellow dot down the column:

Giving you this:

SG

Hi Karol,

Something like a bank account?

Type the starting balance in D2

Formula in D3 (and fill down)

Regards,

Ian.

=D2+B3−C3

karolkollis wrote:

Yes, exactly like that but when I type in -C3 it replaces -C3 with the contents of column A which isn't what I want!

Exactly like what? Instead of typing -C3 have you tried, as described, typing -SUM then clicking the 'value' token and selecting C1 and C2 together？

SG

karolkollis wrote:

Hi Ian

I clicked on cell G800 and then = to open the formula box. Then I typed G799 in the formula box. It changed itself to the contents of cell B799 plus an extra £ symbol.

Why did you type G779? First type SUM so you get the sum formula, click the address token within it, then select (don't type) the cells you want. That sequence is illustrated in detail in my post above. Select the cells and let Numbers do the typing for you.

SG

At Numbers > Numbers > Preferences > General try unchecking 'Use header names as labels'.

To select a range click in first cell, hold down mouse button, while holding it down move the cursor to last cell. In the formula editor you generally do not need to type in the column letter and row number.

SG

karolkollis wrote:

I typed a minus sign. I didn't type any commas!

You may think you didn't type a comma but the evidence strongly suggests that you did in fact do that.😀

What do you see when you turn off the 'Use header names as labels' as suggested?

Highly recommend having a look in your menu at Help > Numbers Help also at the templates at File > New.

SG

Hi Karol,

Please post a screen shot.

Regards,

Ian.

Hi Carol,

To me, your formula seem to have an underline instead of a minus sign.

Also, the comma that follows it is not needed.

Regards,

Ian.