ExcelBanter - Average

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Average (https://www.excelbanter.com/excel-worksheet-functions/165944-average.html)

Glen

Average

How do I average every 50 numbers in a list of 10,000 numbers?

T. Valko

Average

Assume the numbers are in the range A1:A10000

I also assume you want the average of A1:A50, A51:A100, A101:A150, etc.

Enter this formula in C1 and copy down as needed:

=AVERAGE(OFFSET(A$1,ROWS(C$1:C1)*50-1,,-50))

--
Biff
Microsoft Excel MVP

"Glen" wrote in message
...
How do I average every 50 numbers in a list of 10,000 numbers?

All times are GMT +1. The time now is 04:03 AM.