terima kasih atas bantuan para mastah. problems solved. thanks 2012/8/1 dwint ruswanto <[email protected]>
> ** > > > cara lain adalah menggunakan Pivot Tabel > > silakan lihat di lampiran > > salam, > > -dwint- > > Pada 1 Agustus 2012 10:03, hendrik karnadi <[email protected]>menulis: > > ** >> >> >> Ketik function ini pada sel H5, kemudian copy ke bawah, >> =SUMIF($C$5:$C$25,G5,$E$5:$E$25) >> >> Untuk kontrol total, pakai fungsi SUM pada sel E26 dan H17 (jumlahnya >> harus sama, yaitu Rp.60.465.200.000). >> >> Salam, >> Hendrik Karnadi >> >> ------------------------------ >> *From:* Eko NS <[email protected]> >> *To:* [email protected] >> *Sent:* Wednesday, 1 August 2012, 9:36 >> *Subject:* [belajar-excel] menjumlah data kembar >> >> >> permisi para mastah XL. >> >> saya ada permasalahan yg mungkin bisa dibantu. >> saya ingin menjumlahkan data piutang dari perush lain (data ratusan), >> sementara piutang perush tersebut ada beberapa periode. lebih lengkapnya >> ada di attach. >> >> thanks atas bantuannya. >> >> -- >> *Reminder* >> >> *Is not about who we are speaking to, but what we are speaking about?* >> *Is not about who are you, but what would you have become?* >> *The more we learned, the more we understand that we need to learn more* >> >> >> > > -- *Reminder* *Is not about who we are speaking to, but what we are speaking about?* *Is not about who are you, but what would you have become?* *The more we learned, the more we understand that we need to learn more*
