Hi,
I am trying to count consecutive zero's in the table below. I'm guessing this would be an IF/AND formula, but I can't get it right. In the Consecutive 0 column I have manually input the correct answer.
The zero must start in Column A. So the 2 in Consecutive 0 Column adds up Column A and B, then stops as Coluumn C =1. Similarly, the bottom 0 in the Consecutive 0 Column - despite having 4 consecutive 0 from B-E - is zero as it has a number larger than 0 in Column A.
Any help greatly appreciated.
James
I am trying to count consecutive zero's in the table below. I'm guessing this would be an IF/AND formula, but I can't get it right. In the Consecutive 0 column I have manually input the correct answer.
The zero must start in Column A. So the 2 in Consecutive 0 Column adds up Column A and B, then stops as Coluumn C =1. Similarly, the bottom 0 in the Consecutive 0 Column - despite having 4 consecutive 0 from B-E - is zero as it has a number larger than 0 in Column A.
Any help greatly appreciated.
James
CONSECUTIVE 0 | A | B | C | D | E |
0 | 1 | 2 | 4 | 1 | 2 |
2 | 0 | 0 | 1 | 2 | 1 |
1 | 0 | 1 | 2 | 1 | 3 |
4 | 0 | 0 | 0 | 0 | 2 |
0 | 1 | 0 | 0 | 0 | 0 |