[belajar-excel] rumus total

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

[belajar-excel] rumus total

Andrie -
Dear kk,
mohon bantuannya bagaimana rumus utk menghasilkan total stock yang saya beri warna kuning.

Total tsb diambil dari transaksi.

tq

TOTAL STOCK.xlsx (11K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] rumus total

hendrik karnadi
Pada sel B2 ketik :
=SUMIF(transaksi!$A$2:$A$9,A2,transaksi!$B$2:$B$9)+SUMIF(transaksi!$A$2:$A$9,A2,transaksi!$D$2:$D$9)-SUMIF(transaksi!$A$2:$A$9,A2,transaksi!$C$2:$C$9)


lalu copy ke bawah.

Salam,
Hendrik Karnadi



________________________________
 From: Andrie - <[hidden email]>
To: [hidden email]
Sent: Sunday, 11 November 2012, 13:52
Subject: [belajar-excel] rumus total
 

 
Dear kk,
mohon bantuannya bagaimana rumus utk menghasilkan total stock yang saya beri warna kuning.

Total tsb diambil dari transaksi.

tq
 
 
Kid
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] rumus total

Kid
Administrator
Bisa juga dengan array formula Sum :
=SUM((transaksi!$A$2:$A$9=A2)*(transaksi!$B$2:$B$9+transaksi!$D$2:$D$9-transaksi!$C$2:$C$9))
atau memanfaatkan SumProduct (yang bukan array formula) :
=SUMProduct
((transaksi!$A$2:$A$9=A2)*(transaksi!$B$2:$B$9+transaksi!$D$2:$D$9-transaksi!$C$2:$C$9))
lalu copy ke bawah.

Wassalam,
Kid.

2012/11/11 hendrik karnadi <[hidden email]>

> **
>
>
> Pada sel B2 ketik :
>
> =SUMIF(transaksi!$A$2:$A$9,A2,transaksi!$B$2:$B$9)+SUMIF(transaksi!$A$2:$A$9,A2,transaksi!$D$2:$D$9)-SUMIF(transaksi!$A$2:$A$9,A2,transaksi!$C$2:$C$9)
>
> lalu copy ke bawah.
> Salam,
> Hendrik Karnadi
>
>   ------------------------------
> **
>