coba juga,
=SUM(SUMIFS($E$4:$E$7,$B$4:$B$7,H4,$C$4:$C$7,I4,$D$4:$D$7,J4,$F$4:$F$7,{\
"O*";"S*"})*{1;-1})>semoga bermanfaat --- In [email protected], "Mr. Kid" wrote: > > Formula SumProduct : > =SUMPRODUCT(($B$4:$B$7=H4)*($C$4:$C$7=I4)*($D$4:$D$7=J4)*LOOKUP($F$4:$F$\ 7,{"O","S"},{1,-1})*$E$4:$E$7) > > Wassalam, > Kid. > > 2013/1/13 Andrie - > > > ** > > > > > > Master tolong bantuannya lagi...uda buntu nih memikirkannya bagaimana agar > > kolom sisanya terisi sesuai keinginan... tolong diajarin rumusnya...tq > > > > _ > > > > >
