var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Average every 8th row Excel 2007
I have values in C1:C467. I'm trying to calcualte the average of every 8 values.
For example, i want to calculate the average of the values that are in C1:C8, and then the values in C9:C16 etc...
I've tried a few different array formulas and nothing seems to work. Here are two examples of what i've tried so far:
Any help will be great.
The formula refers to values in column C. Copy the formula down starting at row #1. It will display the 8-row average on row #1, and at the beginning of each following set of 8 rows.
=IF(MOD(ROW(),8)=1,AVERAGE(INDIRECT("C"&ROW()): INDIRECT("C" & ROW()+7)),"")
Thank you so much, it worked!