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
Subodh_Tiwari_sktneer's avatar
Subodh_Tiwari_sktneer
Silver Contributor
Nov 06, 2019

Feargal 

You may try something like this...

 

=AVERAGE(OFFSET(INDIRECT("B"&G1),,,G2-G1+1))

  • Feargal's avatar
    Feargal
    Copper Contributor
    Nov 07, 2019

    That works

    Can you explain what it is doing?

    I understand the average bit, but not the use of offset and indirect

Resources