Excel: Count 1 & sum in number series


Hi All, i need a formula for count 1 in number series like :

Column A
1121 Ans . 8
21
11
1431
i need a formula which is sum 1 in given number series thanks in advannce


This question generated 15 answers. To proceed to the answers, click here.

This thread is current as of September 10, 2014.


For more resources for Microsoft Excel