Re: [belajar-excel] Cara menghitung character

[uharyanto uharya...@gmail.com [belajar-excel]]

Array :
=SUM(LEN(A2)-LEN(SUBSTITUTE(A2,",","")))/1

terima kasih.

Salam,
Ujang Haryanto

On 11/03/2015 10:42 AM, uharyanto wrote:

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 har1sn.ex...@yahoo.com [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