Is there a way, using the cell formulas in Numbers, to say "sum of all the cells above this row"? I'm trying to make a ledger of sorts, and I want to have a column that is "how much you've spent so far" for each entry, which is the sum of all the "Price" cells for that row and above.
Is this possible? Thank you in advance for your help!
iMac, OS X Mavericks (10.9)
HI Alexander,
This is similar to what Ian has provided, but uses a different formula that takes advantage of Numbers's ability to automatically fill formulas into new rows IF the same formula is in every cell above the new one.
Column D contains this formula, entered in D2 and filled down to the end of the column.
D2: =SUM(C$2:C2)
NOte that the last sum (120.00) is repeated in the last two rows, where no data has been entered in column C. A revised version of the formula, used in column E, adds a 'switch' to keep cells in this column 'blank' until data has been entered in column C:
E2: =IF(LEN(C)<1,"",SUM($C$2:C2))
Regards,
Barry
HI Alexander,
This is similar to what Ian has provided, but uses a different formula that takes advantage of Numbers's ability to automatically fill formulas into new rows IF the same formula is in every cell above the new one.
Column D contains this formula, entered in D2 and filled down to the end of the column.
D2: =SUM(C$2:C2)
NOte that the last sum (120.00) is repeated in the last two rows, where no data has been entered in column C. A revised version of the formula, used in column E, adds a 'switch' to keep cells in this column 'blank' until data has been entered in column C:
E2: =IF(LEN(C)<1,"",SUM($C$2:C2))
Regards,
Barry
Hi Alexander,
You can do this:
Select the cells that you want to sum (for example, A2 to A4). The sum appears in the bottom left corner of the Numbers window.
Drag the SUM button to cell A5
The formula =SUM(A2:A4) is inserted in A5
Regards,
Ian.
Hi Ian,
…AND the formula in your second example will update if new rows are added above or below the last row of the data to be summed.
Copy of your table and data.
Row added,as shown above, and new data entered in new row 5. New sum appears in row 6:
Regards,
Barry
Hi Alexander,
You could start with a table like this:
To get started,
Cell D2 =C2
Then to continue,
Formula in D3 (and Fill Down)
=D2+C3
Row 10 is waiting for you to fill in details... 😉.
Regards,
Ian.
Numbers formula for "sum of all cells above this row"
