Formula to count characters with criteria

[ian salmon]

I am trying to count the number of charcters in a cell
that satisfy certaijn criteria.
e.g. If cell A1 contains the following then how many 1's
exist in the cell <1111011111110011>

The answer should be 13.

Thanks in advance for any help.

ian

 

[Mike]

=LEN(SUBSTITUTE(A1,0,""))

 

[Aladin Akyurek]

=LEN(A1)-LEN(SUBSTITUTE(A1,"1",""))

where I assume that A1 is formatted as text then 1111011111110011 is entered
in A1.

 

[Ron Rosenfeld]

I am trying to count the number of charcters in a cell
that satisfy certaijn criteria.
e.g. If cell A1 contains the following then how many 1's
exist in the cell <1111011111110011>

The answer should be 13.

Thanks in advance for any help.

ian

=LEN(A1)-LEN(SUBSTITUTE(A1,"1",""))


--ron