On Mon, 19 Dec 2005 13:39:11 -0600, Phillycheese5
wrote:


I'm looking for the formula that will use the largest 5 values in column
A and average the corresponding values in column B. I tried this...

=AVERAGE(IF(A1:A500LARGE(A1:A500,5),B1:B500))

which gave me an answer which was close, but not exact as to when I did
it manually; so something is off.

Any help would be appreciated.
Thanks,
Phillycheese5


Something like:

=SUMIF(A1:A500,"="&LARGE(A1:A500,5),B1:B500) / 5


--ron