#### michaelsmith559

##### Well-known Member

- Joined
- Oct 6, 2013

- Messages
- 881

- Office Version
- 2013
- 2007

I am wanting to have this formula copied down but increment to the next letter as it is copied down. So the formula in BR3 would be "=AVERAGE(W$2:Index(W:W,$BV$2))"

I have tried using average with indirect and have used the evaluate formula to try and fix this, but to no avail. Here is the formula I am using with indirect:

=AVERAGE(INDIRECT(BX2&"$"&ROW(BX2)):INDEX((INDIRECT("BX2")&":"&INDIRECT("BX2")),$BV$2))

This formula results in :"#VALUE!" error.

Any help will be appreciated. Thanks.

Mike