Average based on last 7 values (non-blank/zero)?

Book7.xlsx

The workbook is attached.

Columns B,C,D,E have the desired result in row 18.

What I want the formula to do is starting from row 13, go up and average the next 7 values that are not blank. If its easier, the starting point could be row 4 and I could adjust my data, but just let me know.

Thanks guys.

Originally Posted by XOR LX

Hi,

What if there are less than 7 non-blank entries in the range, as for Brandon Belt, etc.?

Regards

Sorry, my question has changed and I will post another topic.