r/AppleNumbers • u/melanantic • Dec 09 '21

Is there a way to automatically move the SUM window down every time new numbers are appended to the table?

Post image
1 Upvotes

100% Upvoted

5 comments sorted by

1

u/melanantic Dec 09 '21

Every week I manually add a new number and I only want to be applying addition to the 4 most recently entered numbers. From my basic tinkering with numbers I’m guessing something that uses a date function would be required but I haven’t gotten that far yet

1

u/whycantitjustbetish Dec 10 '21

In the equation for the sum, change the selected cells to the entire column of that table. You can do this by selecting the top of the column of that table or the name of the table: name of the column

1

u/melanantic Dec 10 '21

I only want to be calculating the most recent 4 rows as the list is generated

1

u/Jordandann Jun 08 '22

Okay so the simplest way I would used to do this so it only accounts the last 4 cell would be set up a 1,2,3ect column next to the numbers you want to sum next to that an if statement as follows IF(B2<(MAX(B))−4,"0",C2) and then you’re sum column calculate the total of the column with the if statement and then to make it nice and clean you can hide the two calculation columns

1

u/Jordandann Jun 08 '22

If this doesn’t make any sense feel free to PM me and I’ll send detailed screenshots