Coba :
=SUMPRODUCT((MASTER!$C$9:$C$102=$B7)*(MASTER!$G$9:$G$102=G$5)*(MASTER!$B$9:$B$102>=$E$3)*(MASTER!$B$9:$B$102<=$G$3))

Copy ke bawah dan ke kolom STD.

Kid.

2012/5/5 marsidi <[email protected]>

> **
>
>
>  Dear all,****
>
> ** **
>
> Mohon bantuannya seperti dalam attahctment :****
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> Best Regards,****
>
> ** **
>
> *Marsidi*
>
> [email protected]****
>
>  
>

Kirim email ke