Pak Ahmad; Coba begini: =SUMPRODUCT(1/COUNTIF($B$2:$B$45,$B$2:$B$45)*($A$2:$A$45=E2))
Copas kebawah Wassalam ~ Bagus ~ ----- Original Message ----- From: Ahmad Habibillah [email protected] [belajar-excel] To: [email protected] Sent: Thursday, August 14, 2014 3:45 PM Subject: [belajar-excel] need help rumus countif [1 Attachment] Dear All para suhu Excel, mohon bantuannya untuk mendapatkan formula excel dengan kondisi data terlampir. atas bantuannya terima kasih sanget. salam, Ahmad Habibillah
