View Single Post
  #6   Report Post  
Aladin Akyurek
 
Posts: n/a
Default Ping Chip Pearson

Another option is:

H4: 5

H5:

=LARGE(F4:F16,H4)

H6:

=(SUMIF(F4:F16,""&H5)+(H4-COUNTIF(F4:F16,""&H5))*H5)/H4

Lomax wrote:
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