Issues with simple calulations in Numbers.

Show your work.

Specifically, show the formulas in your cells, because the formulas shown in A12:A14 are not valid.

For example, the it's ambiguous, to say the least, what the formula you're showing in A13 is. It could be interpreted several ways, for example:

=B2:B8+C8-D2-D3 (e.g. omitting the SUM() function altogether)

or maybe you mean:

=SUM(B2:B8)+C8-D2-D3 (e.g. the SUM of the values in B2:B8, plus the other values

of maybe you're trying to say:

=SUM(B2:B8+C8-D2-D3) which will use Number's array functionality to repeat the formula for each value of B2:B8 (i.e. =SUM( (B2+C8-D2-D3), (B3+C8-D2-D3), (B4+C8-D2-D3),...(B8+C8-D2-D3)) which, incidentally, equates to the $2143.75 that you have in C13

At the end of the day, you need to be specific as to what you want Numbers to do... I THINK you want:

=SUM(B2:B8) + B8 - D2 -D3

which is the sum of the values in column B, plus the value in column C, minus the values in column D. You just have to be clear.

If I put parentheses in your row 13 formula so it is SUM(B2:B8 + C8-D2-D3) and remove the = at the end I get the same thing in row 13 as you do. This is not the formula you are trying to create. It is summing B2:B8 then, for each of the 7 rows B2 though B8 it is adding (C8-D2-D3) so it comes to SUM(B2:B8) + 7*(C8-D2-D3).

What you want is SUM(B2:B8) + C8 - D2 - D3

The first formula is =B10+C10-D10

No need for SUM

Last one is =SUM(B2:B8) + C8 - SUM(D2:D3)

I use SUM for ranges and usually use + and - for single values (like in my earlier reply), but here is what I think you meant:

=SUM(B10, C10, -D10)

=SUM(B2:B8, C8, -D2, -D3)

=SUM(B2:B8, C8, -D2:D3)

A couple of tips on using Numbers.

You will find adding a Footer Row and putting formulas in that can make life easier. A sum for column B then just becomes =SUM(B).

You can select a range of cells and drag one of the ovals at the bottom into a cell and the formula will be entered automatically.

Quickly calculate a sum, average, and more in Numbers on Mac - Apple Support

SG