Forum Discussion

Feargal's avatar
Feargal
Copper Contributor
Nov 06, 2019

How to create an indirect range reference

How do I create an indirect reference to a range for an average() or Max() function?   So if I want to display the average value in a part of a column, but the part is changeable.   Today I want ...
excel
Formulas and Functions
Twifoo's avatar
Twifoo
Silver Contributor
Nov 07, 2019
OFFSET and INDIRECT are volatile. I prefer the non-volatile INDEX, like this:
=AVERAGE(INDEX(B:B,G1):INDEX(B:B,G2))
Feargal's avatar
Feargal
Copper Contributor
Nov 08, 2019

 

Twifoo 

 

 

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Nov 08, 2019
    Merged cells in Column B might be causing the error.
    • Feargal's avatar
      Feargal
      Copper Contributor
      Nov 15, 2019
      No merged cells

Resources