c306.net
TIL: Moving average with missing periods in Google Sheets
The short answer: =AVERAGEIFS(A1:A99, B1:B99,””&B2 – 30) Values to be averaged are in A1:A99, corresponding dates are in B1:B99. What t…
