Pak Heri; Coba begini: =MIN(625000,IF(COUNTIFS($A$3:$A$16,F$1,$B$3:$B$16,1)=1,SUMIFS($C$3:$C$16,$A$3:$A$16,F$1,$B$3:$B$16,">2")+SUMIFS($C$3:$C$16,$A$3:$A$16,F$1,$B$3:$B$16,1),SUMIFS($C$3:$C$16,$A$3:$A$16,F$1,$B$3:$B$16,">=2")))
Copas kekanan Wassalam ~ Bagus ~ ----- Original Message ----- From: Heri Budianto [email protected] [belajar-excel] To: [email protected] Sent: Thursday, July 17, 2014 1:50 PM Subject: [belajar-excel] penjumlahan dengan banyak ketentuan [1 Attachment] Dear, master Excel mohon pencerahan dan bantuannya untuk permasalahan data excel yang saya hadapi,, Data excel saya lampirkan. Terimakasih.
