Dear Mr Kid,
Thanks a lot...
Regards,
Yudi
________________________________
From: Kid Mr. <[email protected]>
To: [email protected]
Sent: Sunday, September 23, 2012 12:02 AM
Subject: Re: [belajar-excel] Mencocokan Qty , antara excess dan need berdasar
kan wh masing-masing
Penjumlahan multi kriteria umunya dikalkulasi dengan bantuan SumProduct atau
array formula Sum.
Contoh dengan SumProduct :
Pada sheet Excess cell F4 : [sesuaikan rujukan cell dengan data yang ada]
=SUMPRODUCT( ('Need to Stock'!$G$1:$BB$1=$A2) * ('Need to Stock'!$B$2:$B$7=$B2)
* ('Need to Stock'!$A$2:$A$7=F$1) * 'Need to Stock'!$G$2:$BB$7 )
('Need to Stock'!$G$1:$BB$1=$A2) :: data header di 'Need to stock' yang
menunjukkan WH di Excess harus sama dengan WH di sheet Excess
('Need to Stock'!$B$2:$B$7=$B2) :: data produk di 'Need to stock' harus sama
dengan data produk di Excess
('Need to Stock'!$A$2:$A$7=F$1) :: data WH di 'Need to stock' harus sama dengan
data header di Excess yang menunjukkan WH di 'Need to stock'
'Need to Stock'!$G$2:$BB$7 :: area nilai-nilai yang akan diambil dan di sum
yang ada di 'Need to stock'
Wassalam,
Kid.
2012/9/22 Yudi Dwiyono <[email protected]>
>
>Dear All,
>
>
>Please help me...
>
>
>
>Thanks
>
>Yudi
>
>
>________________________________
> From: Yudi Dwiyono <[email protected]>
>To: "[email protected]" <[email protected]>
>Sent: Saturday, September 22, 2012 4:30 PM
>Subject: [belajar-excel] Mencocokan Qty , antara excess dan need berdasar kan
>wh masing-masing
>
>
>
>
>Dear Master Excel,
>
>
>Adakah rumus agar qty dari excess sama dengan Qty need ?
>Sebagai contoh, dari sheet need stock WH no 064 mendapat supply dari 062
sebanyak 29 Pcs, bagaimana membuat rumus sebaliknya jik 062 mensupply ke WH 064
( WH need to stock ) sebanyak 29 Pcs juga.
>Contoh terlampir...
>Thanks..
>
>
>Yudi.
>
>
>
