Nothing beats self-teaching...

Apparently I need to say "greater than the 6th largest value" which
would give me the largest 5. In case anyone was interested, here is
the formula that works:

=AVERAGE(IF(B3:B500LARGE(B3:B500,6),D3:D500)) ...use CSE.


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