Sorry about that. Don't know what I was thinking :(
Try: =AVERAGE(IF((A2:A11="A")*(B2:B11="Agent"),C2:C11))
confirmed with CTRL+SHIFT+Enter
--
Vito
------------------------------------------------------------------------
Vito's Profile:
http://www.excelforum.com/member.php...o&userid=29182
View this thread:
http://www.excelforum.com/showthread...hreadid=489187