# Count continuous series

1. ## Count continuous series

How to count the values ​​in the column if the same are in a continuous sequence. Please see attach  Register To Reply

2. ## Re: Count continuous series

I did this using helper columns - you can probably combine

See attached  Register To Reply

3. ## Re: Count continuous series Originally Posted by mike65535 I did this using helper columns - you can probably combine
Thank you Mike for the appearance
The idea is good.
I'm trying to find a formula without extra help columns (if there is a possibility)
regards  Register To Reply

4. ## Re: Count continuous series

In B2

=IF(OR(A3="",ABS(A2-A3)>MAX(ABS(A2),ABS(A3))),COUNTBLANK(B\$1:B1)-SUM(B\$1:B1)+1+COUNT(B\$1:B1),"")

Copy down  Register To Reply

5. ## Re: Count continuous series Originally Posted by Ace_XL In B2
The idea is OK, but then the problem with zero (0).
If a cell in column A contains the value zero then there is no break between series
Is there a possibility that the formula ignores the zero (0) and return an empty cell in the same row  Register To Reply