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

 

Attachment: COGS Book1.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Kirim email ke