Hi:
maybe something like this:

=((SUMIF(F10:G13,F17,G10:G13))/COUNTIF(F10:F13,F17))

where range f10:g13 is list of sports

f17 is sport to be averaged

adjust ranges as needed

hth

plettieri


--
plettieri
------------------------------------------------------------------------
plettieri's Profile: http://www.excelforum.com/member.php...o&userid=34531
View this thread: http://www.excelforum.com/showthread...hreadid=544914