Using =address to provide address location for =average

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to use =address to supply the cell addresses for the range in
the average function. I can get all the pieces to work separately but can't
nest the =address function within =average
 
Yes, but you need to use INDIRECT to convert the string
created from ADDRESS to a real reference. For example:

=AVERAGE(INDIRECT(ADDRESS(1,1)),INDIRECT(ADDRESS(5,1)))

This is the same as:

=AVERAGE(A1,A5)

HTH
Jason
Atlanta, GA
 
Jason said:
Yes, but you need to use INDIRECT to convert the string
created from ADDRESS to a real reference. For example:

=AVERAGE(INDIRECT(ADDRESS(1,1)),INDIRECT(ADDRESS(5,1)))

This is the same as:

=AVERAGE(A1,A5)

HTH
Jason
Atlanta, GA



addresses for the range in


separately but can't
Click to expand...
Thanks Jason - that did it.

Allen
 
Back
Top