Terima kasih Mr Bagus.-Emi Lestari
On Tuesday, September 9, 2014 12:49 PM, "'Bagus' [email protected] [belajar-excel]" <[email protected]> wrote: Mbak Emi; Coba begini: =COUNTIFS($B$4:$B$16,$G4,C$4:C$16,">0") Copas kekanan dan kebawah Wassalam ~ Bagus ~ ----- Original Message ----- >From: Emi [email protected] [belajar-excel] >To: [email protected] >Sent: Tuesday, September 09, 2014 11:17 AM >Subject: [belajar-excel] Tanya Sumproduct (Count) [1 Attachment] > > >Teman BeExcel, >Bagaimana menghitung bilangan (COUNT) bagi setiapnegara bagi kategori A dan B. >Apakah ada rumus lain selain SUMPRODUCT? >Terima kasih > > >-Emi Lestari > >
