Re: [belajar-excel] Cara menghitung character

Tue, 10 Mar 2015 20:47:20 -0700 

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 [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

Kirim email ke