What arrayformula can I put in a Google Spreadsheet cell to count cells with contents horizontally?-CodePudding

Here's a link to the spreadsheet (anyone with link can view)

I basically need an arrayformula to put in cell L2 to have the same results in col J

CodePudding user response：

try:

=INDEX(LEN(SUBSTITUTE(FLATTEN(QUERY(TRANSPOSE(IF(E2:I4="",,1)),,9^9)), " ", )))

CodePudding user response：

You can use an if to convert each column into numbers and just sum it up. Try applying the formula below to your sheet.

=arrayformula(if($B$2:$B="","",if($E$2:$E="",0,1) if($F$2:$F="",0,1) if($G$2:$G="",0,1) if($H$2:$H="",0,1) if($I$2:$I="",0,1)))