find counta() per row using arrayformula()

Question

I have this table :

https://docs.google.com/spreadsheets/d/1ICEL33X3ADz7XEH2Cmi1p6mrYT2RqPwbtBjCHWoNkoA/edit?usp=sharing

Basically i want to do counta() per row but using arrayformula(). The basic formula i use in A2 :

=counta(TRANSPOSE(B2:2))

Thanks

Answer 1

There are many ways to do that, but try a query smush to get started:

=arrayformula( len( substitute( transpose( query( transpose( left(B2:Z, 1) ), "", 9^9 ) ), " ", "" ) ) )

There are more than 50,000 blank rows in your sample spreadsheet. You may want to delete them before you apply the formula.