Hi,

Am Fri, 27 Jan 2012 20:54:49 +0100 schrieb Claus Busch:

=SUMIF(F19:F55,F56,C19:C55)/COUNTIF(F19:F55,F56)

if you use xl2007 or higher, you can also try:
=AVERAGEIF(F19:F55,F56,C19:C55)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2