The INDIRECT("1:5") converts the text string "1:5" to a range
reference that can be used by the ROW function.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Lomax" wrote in message
news:MLh4f.88$282.15@dukeread08...
I have a list of $ values in F4-F16 need to average the largest
5 amounts.
I copied this from Your website and made a slight mod to
accommodate the 5 instead of 10 as on the site.
={AVERAGE(LARGE(F4:F16,ROW(INDIRECT("1:5"))))}
I understand all but the (indirect("1:5)). I hate to be a
bother but could you explain this part? What does the indirect
function perform?
Thanks lomax