Count 1 in number series

[skr971]

Hi,

i have a data like this :

[TABLE="width: 194"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Column A[/TD]
[TD]Column B (Ans)[/TD]
[/TR]
[TR]
[TD]1231[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]231[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]4531[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]1121[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]21114[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
now i need to calculate that how many times 1 Comes like that column B
can you help me on the same....

thanks in advance
Regards
Sunil Kumar

 

[Aladin Akyurek]

B2, copied down:

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

 

[skr971]

Thanks it's working fine..

 

[Aladin Akyurek]

Thanks it's working fine..

You are welcome.