Thank you but I am still having an issue.

If I want the avergage of the last 8 weeks(Row 5) if row 7 contains "RP" and I want this value returned in cell CF8 which formula do I use?
I want to be able to copy this formula across row 8 so that when I dump new data in new rows it will automatically populate a new average number.

For the value I need in CF8, to calculate it manually is would need the average of: BS8, BT8, BY8, BZ8, CA8, CC8, CD8 and CE8 which would give me the value of 4129.75

Thank you so much for the much needed help!