Hai Mr Bond,
Sila lihat file terlampir. Formula untuk kolom summary berbeda disetiap “Plant Number” begitupun di kolo H dan I, namun formula untuk kolom “Value” sama. Hanya itu masukan dari saya, mungkin teman2 yang lain ada yang lebih efisien formulanya. Hehehe... Salam, DD From: James Bond myname...@yahoo.com [belajar-excel] [mailto:belajar-excel@yahoogroups.com] Sent: 05 Februari 2015 04:01 To: belajar-excel@yahoogroups.com Subject: [belajar-excel] Memfilter data pada kolom dan mensummarykan nilai-nya [1 Attachment] Dear Be Exceller, Selamat pagi, mohon bantuan pencerahannya... Seperti terlampir saya masih bingung bagaimana memfilter kolom E dan kemudian hasil filter tsb di total lagi cost-nya dengan melihat kembali kolom D.. Pada lampiran telah saya isi manual kolom E & F bagaimana hasil yang diharapkan. Terima kasih. Salam, James _____ This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.
Index 3.xlsx
Description: MS-Excel 2007 spreadsheet
