You have to use greater than or equal to, instead of just greater than:

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

Still array entered (CTRL+SHIFT+ENTER)

--
Regards,
Dave


"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


--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=494679