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