Excel: count 1 for 15 or more consecutive 1s

Guys, I have a column consisting of 1s and 0s/spaces. I want to count 1 for every 15 or more consecutive 1s. The result should be the number of times of consecutive fifteen or more 1s appearing on the list. What would the function be? Please help me on this. TY. Regards, D4ND4N

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

This thread is current as of October 01, 2014.

For more resources for Microsoft Excel