Forum Discussion

steven755's avatar
steven755
Copper Contributor
Oct 26, 2023

nesting functions within average =AVERAGE(CONCATENATE(U26,":",U27))

=AVERAGE(CONCATENATE(U26,":",U27))   Trying to take an average of a sample data set within a large table.  What is the correct syntax or is it even possible? Trying to take an average of a smalle...
excel
HansVogelaar's avatar
HansVogelaar
MVP
Oct 26, 2023

steven755 Use INDIRECT to convert the result of CONCATENATE (a text string) to a range reference:

 

=AVERAGE(INDIRECT(CONCATENATE(U26,":",U27)))

 

or

 

=AVERAGE(INDIRECT(U26&":"&U27))

  • steven755's avatar
    steven755
    Copper Contributor
    Oct 26, 2023
    That works
    Thanks

Resources