Results 1 to 3 of 3
  1. #1
    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. #2
    Join Date
    Jan 2002
    Location
    Bay Area
    Posts
    511
    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. #3
    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
  •