mas nor dayat, *nganggo menyan, banyu wolu kembang, telor pitek*
wes ewes ewes ewes
wes ewes ewes ewes
iki lho jampi ne:
nang C5
=IF(SUMPRODUCT(('DATA 1'!$A$3:$A$5=HASIL!$A5)*('DATA
1'!$B$3:$B$5=HASIL!B$4))=0,"",SUMPRODUCT(('DATA
1'!$A$3:$A$5=HASIL!$A5)*('DATA 1'!$B$3:$B$5=HASIL!B$4)*('DATA
1'!$C$3:$C$5)))
ojo lali mbek mas zamproduct thooo...
regards,
abimono
2008/9/4 nor hidayat <[EMAIL PROTECTED]>
> pleace para master xl mania tolong jampe-jampein masalah saya biar lancar
> thanks
>
>
>
>
> Dayat
>
dayat 001.xls
Description: MS-Excel spreadsheet
