Average of entries

[jackyT]

I have a long list of numbers on a row. However, i would like to have only the average of the last 25 entries on the row. Can anyone help me with a formula? Thanks in advance

[ChemistB]

Assuming you're going to be adding data to this row, you'll need to work with dynamic ranges. Assuming your data is in column A and begins in A2.
In any empty cell, you'd add this formula

Please Login or Register  to view this content.

Does that work for you?

ChemistB

[jackyT]

Thank you very much... Resolved per your answer...

[jackyT]

Staying with the same problem.
After obtaining the average of the 25 latest input, i would like to further find the average of the 10 of the highest number from the 25?

[NBVC]

Try:

=AVERAGE(LARGE(OFFSET($A$2,COUNTA($A$2:$A$50000)-25,0,25),{1,2,3,4,5,6,7,8,9,10}))

[jackyT]

Thanks....