count if three colums match .
 

Hi experts.


i have a data like this i wanna count if continuous three zero and after this 0 in a range if this criteria tow time in a range then output 2

colums no
a1 0
a2 0
a3 0
a4 1
a5 0
a6 1
a7 0
a8 0
a9 0
a10 5


Regard's

Trishal Bhola