Forum Discussion
Rolling Average
Is there an easy way to get the rolling average? I am using the simple average formula but it is too manual.
=averageifs will not work since on week 2 and 3, there will be two or more criteria already. the Week 2 result should be the average of all Week 1 and Week 2 values. and on week 3 it is should be the average of the values of Week 1, 2, and 3.
If you would use numbers for your weeks instead of text:
=AVERAGEIFS(Table1[Values],Table1[Week],"<="&D2)