average f(x)

[briank]

Any ideas why this won't work?
=average(ADDRESS(4,26):address(4,33))

 

[Chip Pearson]

You have to convert the strings returned by ADDRESS to an actual range using
INDIRECT. E.g.,

=AVERAGE(INDIRECT(ADDRESS(4,26)&":"&ADDRESS(4,33)))

 

[Harlan Grove]

You have to convert the strings returned by ADDRESS to an actual range using
INDIRECT. E.g.,

=AVERAGE(INDIRECT(ADDRESS(4,26)&":"&ADDRESS(4,33)))

...

Or eliminate the unnecessary ADDRESS calls. Assuming this is actually
parametrized as =AVERAGE(INDIRECT(ADDRESS(w,x)&":"&ADDRESS(y,z))), try

=AVERAGE(INDIRECT("R"&w&"C"&x&":R"&y&"C"&z,0)) [safest]

or

=AVERAGE(OFFSET($A$1,x-1,w-1,y-w+1,z-x+1)) [shortest & maybe fastest]