Subtotals

jwa0 · Apr 20th, 2002, 12:57 PM

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. · Apr 20th, 2002, 01:09 PM

Enter...

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

...into B1 and copy down.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 20th, 2002, 12:57 PM	#1
jwa0 New Member Join Date: Apr 2002 Posts: 3	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

Apr 20th, 2002, 01:09 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Enter... =IF(MOD(ROW(),5),"",AVERAGE(OFFSET(A1,-4,,5))) ...into B1 and copy down.