Forum Discussion
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 smaller subset of a large database.
U26 and U27 will be text that defines the cells to extract the data for the average.
2 Replies
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))
- That works
Thanks
