+ Reply to Thread
Results 1 to 3 of 3

Finding Average two consecutive rows in a column

  1. #1
    Forum Contributor
    Join Date
    11-22-2003
    Location
    Newport, Rhode Island
    MS-Off Ver
    2013
    Posts
    148

    Finding Average two consecutive rows in a column

    Hello All,

    Using Excel 2010, Windows 7.
    In the attach worksheet I have numerical values in Column B and I want to find the average of B1:B2, B3:B4, B5:B6, B7:B8 and B9:B10 and place the values in Column C.
    I have the formula in column C1:C5 =AVERAGE(INDIRECT("B&MAX(1,2*(ROW()-1))&":B"&2*(ROW()-1+1))) but the results are off as shown in column E. How can I tweak the formula to get the correct values in E. Thanks in advance for any help.

    Mike
    Attached Files Attached Files
    Last edited by windme; 04-28-2013 at 11:54 AM.

  2. #2
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,508

    Re: Finding Average two consecutive rows in a column

    Hi Mike,

    You don't need the 'MAX' in there in this case. Simply =AVERAGE(INDIRECT("B"&(ROW()*2)-1&":B"&ROW()*2)) in cell C1 and copied down will do the trick.

    Regards

  3. #3
    Forum Contributor
    Join Date
    11-22-2003
    Location
    Newport, Rhode Island
    MS-Off Ver
    2013
    Posts
    148

    Re: Finding Average two consecutive rows in a column

    Thanks so much XOR LX for your help, works great!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1