Ikutan coba jawab yah
=SUM(LEN(A2)-LEN(SUBSTITUTE(A2,",","")))/LEN(",")
terima kasih.Salam, Ujang Haryanto On 11/03/2015 10:14 AM, ris ha [email protected] [belajar-excel] wrote:
Assalamu'alaikum para suhu excel yg baik hati
Bagaimana caranya menghitung karakter "," (koma) pada kasus spt dibawah.
Data Jumlah
1,2 1
1,2,3 2
4,10,18 2
5,9,10,15
3
Terima kasih
Salam
Haris
