How to create a long run program [duplicate]

This question already has answers here: Google Sheets - How to count streaks of non-zero numbers on one column (2 answers) Closed 12 hours ago.

I'm trying to create a formula, likely used in Google Sheets, that will count the number of consecutive "hits" forward from the first recorded event and then another that will count in reverse from the last recorded event.

Example

X X X X X X X X O 开发者_开发知识库X

In this example, the consecutive hits forward would be "8" and the consecutive hits in reverse would be "1"

I have been unsuccessful in coming up with a formula

---

try:

=LEN(SPLIT(SUBSTITUTE(A1, " ", ), "O"))

and

=INDEX(LEN(SPLIT(SUBSTITUTE(A1, " ", ), "O")),,COLUMNS(SPLIT(A1, "O")))