Or this array formula:

=AVERAGE(IF(Performance!$A$2:$A$1000=A2,Performanc e!$G$2:$G$1000))

Biff

"SteveC" wrote in message
...
=SUMPRODUCT(--(Performance!$A$2:$A$1000=A2),--(Performance!$G$2:$G$1000))/COUNTIF(Performance!$A$2:$A$1000,A2)

Thanks to Alan at another post...