Bisa pakai formula SUMIF() Contohnya terlampir.
Iseng ________________________________ From: Harif Djafari <[email protected]> To: "[email protected]" <[email protected]> Sent: Tuesday, February 26, 2013 5:27 PM Subject: ]] XL-mania [[ mengambil nilai cogs berdasarkan no DO Dear para master XL-Mania, Saya mohon pencerahan rumus untuk mengambil nilai COGS berdasarkan no DO Untuk lebih jelasnya file terlampir. Regards, Harif
COGS Book1.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

