I have data in excel like this
<tbody>
</tbody>
I want to countif consecutive two cells have "SAY value" 0
So first 4 columns will return frequency function =2
if all columns given as cell range for formula, then frequency should be = 3
as at end only 3 columns have two consecutive zero cell.
How can i write formula. I tried if and array but making mistake.
A | B | C | D | E | F | G | H | I | J | K | L | M | N |
0 | 0 | 0 | 0 | 22 | 55 | 7 | 3 | 0 | 0 | 0 | 5 | 44 | 5 |
<tbody>
</tbody>
I want to countif consecutive two cells have "SAY value" 0
So first 4 columns will return frequency function =2
if all columns given as cell range for formula, then frequency should be = 3
as at end only 3 columns have two consecutive zero cell.
How can i write formula. I tried if and array but making mistake.