Finding Average two consecutive rows in a column

**windme** · 04-28-2013, 11:18 AM

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

**XOR LX** · 04-28-2013, 11:41 AM

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