2 Week Rolling Average

I am pretty basic when it comes to Excel 2010.

I need help determing a rolling average for the past two weeks in column L on the WOH tab for every 2 columns labeled "COMP" on the Completed Work tab.

I do not want to see lovely DIV/0! error however zeroes must be included in the 2 week calculation if any, ignoring the blanks.

I'm not sure if a helper column is needed on the Completed Work tab in order to calculate the rolling average.
I have tried different suggestions from google and assorted tutorials but I would assume I'm not inputting the formulas correctly...

If I insert a column to the left of the Sun 11/1 data, and insert the following array formula


=AVERAGE(IF(MOD(COLUMN(C4:GF4)-COLUMN(C4),3)=0,IF(C4:GF4>0,C4:GF4)))


I get the average for every third column just fine... But I just want to see the average for the past two weeks based on today's date starting in WOH!L3; not an average of all the data in every third column.

Does the attached help ?
View attachment Copy of TESTER2.xlsx

Pecoflyer said:

Does the attached help ?
View attachment 4134

Click to expand...

It does, thank you much!!!!