indirect function - how to change row by dragging cell horizontally

[j_brubaker]

Hi everyone,

In B3, I have the equation:

=AVERAGE(INDIRECT("b"&(today()-$A2+5)):INDIRECT("b"&(today()-$A3+5)))

When I drag this equation horizontally the two ["b"}'s stay as b's.

What can I do to have the two ["b"}'s change to the new column with everything else in the equation staying constant?

Thanks in advance,
-Josh

 

[FormR]

Hi, you can try this alternative, which also has the added advantage of not being volatile.

=AVERAGE(INDEX(B:B,TODAY()-$A$2+5):INDEX(B:B,TODAY()-$A$3+5))

 

[j_brubaker]

This worked perfectly! Thank you