Subtotals

[jwa0]

Yesterday I posted this question, but today it was gone.

Start with a list of n numbers in column A. Compute the average of the first five numbers and display it in column B; do the same for each successive block of 5 numbers. I don't konw how to do it.

John Adans


J

 

[Mark W.]

Enter...

=IF(MOD(ROW(),5),"",AVERAGE(OFFSET(A1,-4,,5)))

...into B1 and copy down.