[belajar-excel] BO

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] BO

Andrie -
Master tolong bantuannya lagi...uda buntu nih memikirkannya bagaimana agar kolom sisanya terisi sesuai keinginan... tolong diajarin rumusnya...tq

BO.xls (26K) Download Attachment
Kid
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] BO

Kid
Administrator
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 - <[hidden email]>

> **
>
>
> Master tolong bantuannya lagi...uda buntu nih memikirkannya bagaimana agar
> kolom sisanya terisi sesuai keinginan... tolong diajarin rumusnya...tq
>
>  _
>
>

re-BO.xls (35K) Download Attachment