cell C16 formula : =SUMIF($B$3:$B$12,B16,$C$3:$C$12) copy formula down. semoga membantu :p <https://www.avast.com/lp-safe-emailing?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> This email has been sent from a virus-free computer protected by Avast. www.avast.com <https://www.avast.com/lp-safe-emailing?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> <#DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
2015-12-13 10:18 GMT+07:00 Eko Noviyanto [email protected] [belajar-excel] <[email protected]>: > > > Dear Master, > > Mohon bantuannya memberikan formula untuk penjumlaha per departemen dalam > lampiran email ini. > > Atas perhatian dan bantuannya saya ucapkan terima kasih. > > Salam, > Nopenk > > > -- regards, Wira 鄧又銘 on desktop FireFox
