i want find formula to count consecutive cells matching string (e.g. 1) but the counting of the consecutive cells to start after the 3rd consecutive entry
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
<tbody>
</tbody>
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>
i got stuck here 
