There isn't a specific single function but in general if you want the
average of B1:B10 when A1:A10 is "xxx" then either

=AVERAGE(IF(A1:A10="xxx",B1:B10))

confirmed with CTRL+SHIFT+ENTER or

=SUMIF(A1:A10,"xxx",B1:B10)/MAX(1,COUNTIF(A1:A10,"xxx"))

which just requires ENTER


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=536854