# Thread: Average every 8th row Excel 2007

1. Registered User
Join Date
Mar 2010
Posts
30

## Unanswered: Average every 8th row Excel 2007

Hello,

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:

=AVERAGE(INDIRECT("C"&MAX(1,9*(ROW()-1))&":C"&9*(ROW()-1)+8))

=AVERAGE(IF(MOD(ROW(OFFSET(\$C\$1:\$C\$467,1-1,0))-ROW(OFFSET(OFFSET(\$C\$1:\$C\$467,1-1,0),0,0,1,1)),8)=0,OFFSET(\$C\$1:\$C\$467,1-1,0),FALSE))

Any help will be great.
Thanks!

2. Registered User
Join Date
Jan 2002
Location
Bay Area
Posts
513
Try this:
Code:
`=IF(MOD(ROW(),8)=1,AVERAGE(INDIRECT("C"&ROW()): INDIRECT("C" & ROW()+7)),"")`
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.

3. Registered User
Join Date
Mar 2010
Posts
30
Thank you so much, it worked!

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•