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 setiap negara bagi kategori A dan 
B.
  Apakah ada rumus lain selain SUMPRODUCT?
  Terima kasih


  -Emi Lestari



  

Kirim email ke