coba:
=SUMPRODUCT(1/COUNTIF($C$8:$C$28,$C$8:$C$28))

From: [email protected] [mailto:[email protected]] On 
Behalf Of neza ibaneza
Sent: Wednesday, November 27, 2013 10:13 AM
To: [email protected]
Subject: [belajar-excel] menghitung macam data dalam satu kolom [1 Attachment]

  
Assalamualaikum
dear all
salam b-excel

Master excel yang dirahmati Allah, mohon bantuannya cara menghitung jumlah 
jenis data dalam satu kolom
tetapi tanpa kolom bantuan.. file terlampir

Salam
Neza
,___

Kirim email ke