Hi everyone, I’m looking for a little help. How can I write a formula to go back the last 7 entries for a column and total them? Example, how many apples did I eat in the last seven entries (days)? And as I add on to the column, it will keep totalling just the most recent 7. I want to use this to ca…

@Chris_Harris I added a third section to that doc (see below). First, let’s determine how you want to calculate the rolling 7-day sums, and then we can determine how best to handle the dimension of multiple drivers. In a spreadsheet, you calculate rolling sums by targeting the coordinates (column…

Total back the most recent 7 days (entries)

Ander May 7, 2020, 12:32pm 2

@Chris_Harris

See if this thread helps: How do I show the last 7 days in a formula?

1 Like

Topic		Replies	Views
How do i end my row with sum off all previous columns?	18	4127	March 5, 2022
How do I show the last 7 days in a formula?	3	1568	May 2, 2020
Sum each column in this row. ie Sum a range of columns	11	1761	October 4, 2023
NETWORKDAYS.INTL() Workaround?	3	1009	June 3, 2020
Dates within a sum formula	2	672	May 25, 2020

Total back the most recent 7 days (entries)

Related topics