3 week rolling average, excluding blanks

[ndc1987]

Hi,

I'm looking for help with a 3 week rolling average.
I have my spreadsheet set up with Data in columns NY through to OT as below

NY NZ OA OB
Week 1 Week 2 Week 3 Week 4
10 20 Blank 15

The data goes right through to Week 22 (column OT). From column OU onwards I am calculating the average.

What I want is for a moving average of the last 3 weeks in which the cell has a value.

For example I would like the average at Week 4, so the average should be (10+20+15)/3.

Then for the average at Week 5, week 5 score + 15 + 20 /3 and so on.

Thanks for your help

 

[Aladin Akyurek]

That works perfectly, than you very much for your help!!

You are welcome. Thanks for providing feedback.