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 |