michaelsmith559
Well-known Member
- Joined
- Oct 6, 2013
- Messages
- 881
- Office Version
- 2013
- 2007
In column bx starting in row 2, I have letters listed sequentially, starting with the letter V. Here is the formula I currently have in BR2: "=AVERAGE(V$2:INDEX(V:V,$BV$2))"
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
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