There's a question on this forum that asks how to get a 7 day running total and running average. It's available here and it reads like this:
I have a Google Spreadsheet tracking figures day by day. I want to add a column with a 7 day running total (sum of last 6 rows plus current row) and a column with a 7 day running average (average of last 6 rows plus current row).
I've managed to create a running total fine (Say numbers in column A, then B1 = A, B2 = B1 + A2 and drag the formula down to copy), but can't work out a 7 day running total.
There's a handy solution by THEMike that solves the problem, but without ArrayFormula. My question is, how could I do the same thing using ArrayFormula?
Let's assume the data looks something like the following:
| Date | Data | 7 Day Running Total | 7 Day Running Average | |--------|------|---------------------|-----------------------| | 6/1/15 | 3 | | | | 6/2/15 | 4 | | | | 6/3/15 | 4 | | |