Mas bro, coba ketik formula :
=IF( B5= "B",SUMIFS ( $D$5 :D5 ,$C$5 :C5 ,C5, $B$5 :B5, "A" )- SUMIFS( $D$5: D5, $C$5 : C5, C5, $B$5: B5, "B"), "") Di cell e5 (f5 jg boleh, buat bahan pembanding) n copas y kebawah... br. odong
Bls: [belajar-excel] Penjumlahan Multi
'[email protected]' [email protected] [belajar-excel] Fri, 20 Jun 2014 07:04:13 -0700
- [belajar-excel... 'sh.Ronald' [email protected] [belajar-excel]
- Re: [bela... 'Bagus' [email protected] [belajar-excel]
- Bls: [bel... '[email protected]' [email protected] [belajar-excel]
- Re: [bela... 'Mr. Kid' [email protected] [belajar-excel]
