average last 8 values of a columns as new numbers entering

hello,
I guess I know how to find average or sum or nth rows, it always shows average of last 8 rows.
but wondering if it is possible getting last 8 columns average of the numbers in a range ?
like what si average for 1, or 2, or 10 in last 8 rows?

Thank you screenshot.6114.jpg

Assuming there are no blanks in your data

Formula:

Please Login or Register  to view this content.

So you want last 8 rows, last 8 columns?

Formula:

Please Login or Register  to view this content.

=AVERAGE(OFFSET($C$3,COUNT($C:$C)-8,COUNT($C$3:$ZZ$3)-6,8,6))

I have no idea what the numbers in Column A represent or what percentage of what cells (Summed? Averaged?) you want. Maybe a few example calculations?

I assum that data row can expand till 100

=SUMPRODUCT((ROW($C$2:$H$100)>=(COUNT($C$2:$C$100)-8+2))*($C$2:$H$100=A2))

with 8 is given order number, 2 is starting row or data (Cell C2)