average f(x)

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

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)) )


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com



"briank" wrote in message
...
Any ideas why this won't work?
=average(ADDRESS(4,26):address(4,33))

"Chip Pearson" wrote...
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]

--
Never attach files.
Snip unnecessary quoted text.
Never multipost (though crossposting is usually OK).
Don't change subject lines because it corrupts Google newsgroup archives.