Mr lifeseeker,

I have verified the formla .It is working fine.
In Sheet A Data Entry,
The average of col D is 5.1 and thee are 5 rows which satisfies your condition (colC=p1 ,colF=A)
Sumproduct gives 5.1*6=30.6.

Pl clarify what actually you want.