I want to count the number of columns containing entries in them per row.
I used the formula :
=ArrayFormula(countif($H$4:$4,"<"&$A$4:$A)/count($H$4:$4))
-
Please read how to and share a test sheet so as you can be easier helped.– marikamitsosCommented Feb 10, 2020 at 11:50
Add a comment
|
1 Answer
this might work...
=ARRAYFORMULA(IF(A4:A="",,MMULT(N(OFFSET(H4,,,ROWS(H4:H),COLUMNS(H4:4))<>""),SEQUENCE(COLUMNS(H4:4),1,1,0))))
