Try this regular formula:
=SUMPRODUCT(SUMIF(B4:B6,B9:B10,C4:C6))/SUMPRODUCT(COUNTIF(B9:B10,B4:B6))

Does that help?