# Consecutive Number Counting Formula

Oct 9, 2009In cells v43:v52 I have data which will change often the data is always either a 1,-1 or a 0, I need a way to count from the bottom up and ignore anything that is not part of the chain. It can also contain 0 in rows that are not populated yet but the 0s will always be on the bottom and never in the middle or top.

I.E. in 3 weeks it could be

1

1

1

0

0

0

0

0

0

0

0

0

I would want the formula to spit out 3 because it was 1 3 times in a row..

Now say in week 5 it is

1

1

1..............................