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
'odongna...@yahoo.com' odongna...@yahoo.com [belajar-excel] Fri, 20 Jun 2014 07:04:13 -0700
- [belajar-excel... 'sh.Ronald' sh.ron...@yahoo.co.id [belajar-excel]
- Re: [bela... 'Bagus' ba...@kingjim.co.id [belajar-excel]
- Bls: [bel... 'odongna...@yahoo.com' odongna...@yahoo.com [belajar-excel]
- Re: [bela... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
