so if you have on a single row 5 consecutive times number 1 - the result should be 2 because the counting should start after 3rd entry

if you have 8 consecutive entries of number 1 but somewhere between them there is blank cell that should be also considered as single consecutive entry and the result should be 5

as shown on a row 9 - there are 9 consecutive times the number 1

the result is 6 because it should count only after the 3rd consecutive number 1

on row 10 is counting again only after the 3rd consecutive number 1

there are 2 consecutive entries with another number between them and it should be considered as two different consecutive entries of 1 - so the result should be 2

additionally on row number 11 are shown 2 consecutive entries with blank cell between them should be also considered as 1 consecutive entry

the numbers which the formula should count are shown below in red

A1 | B | C | D | E | F | G | H | I | J | K |

2 | Entries | Result | ||||||||

3 | 1 | 2 | 1 | 1 | 2 | 1 | 1 | 1 | 2 | 0 |

4 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 2 | 2 | 1 |

5 | 1 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 2 | 2 |

6 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 3 |

7 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 4 |

8 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 5 |

9 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 6 |

10 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 2 |

11 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 5 |

<tbody>

</tbody>