Dear Pak Muklis,
Saya coba bantu menggunakan kombinasi fungsi sumif, if, or & and pada cell F2 lalu dicopy kebawah sbb : =IF(OR(AND(D3<>D2,D3=D4),AND(D3<>D2,D3<>D4)),SUMIF($D$3:$E$22,D3,$E$3:$E$22),"") Semoga sesuai harapan & bermanfaat.. Best regards, Primas Adexa ________________________________ From: "[email protected]" <[email protected]> To: [email protected] Sent: Tuesday, January 7, 2014 9:40 PM Subject: ]] XL-mania [[ Mencari rumus total Weight Mohon bantuan bagaimana cara untuk mencari rumus secara otomatis pada total fielld Weight Regards, Muklis
Solusi - Rumus total weight.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
