Rolling avg last three

[jpernice]

Hello

What is the best way to pull the average in row for the last three cells

c6 d6 e6 f6 g6 h6
600 100 2500 300 500 600 700


Thanks

[JieJenn]

Try =AVERAGE(OFFSET($C$1,0,(COUNT(1:1)-3),1,3))

[jpernice]

Hello

Thanks

Is there someway to addthis forumale on the same line and all so move the range forward after add new column after the last row?

[JieJenn]

The formula is dynamic, so it will always average the last three cells as you add more numbers.