Kang Bagus....
many thanks..... its work.. mantaps... ciayo untuk Kang Bagus and belajar-excel Ahmad Habibillah Pada Jumat, 15 Agustus 2014 9:29, "'Bagus' [email protected] [belajar-excel]" <[email protected]> menulis: 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 > > > > > > >
