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 - <[email protected]> > ** > > > Master tolong bantuannya lagi...uda buntu nih memikirkannya bagaimana agar > kolom sisanya terisi sesuai keinginan... tolong diajarin rumusnya...tq > > _ > >
re-BO.xls
Description: MS-Excel spreadsheet
