# Finding Average two consecutive rows in a column

1. ## 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

2. ## 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. ## Re: Finding Average two consecutive rows in a column

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

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

#### 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