View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] trishalbhola041@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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