Help with Array function

[Hindustani]

I have 4 rows and 4 columns let us say from A1:D4.
What I am trying to do is: to get the number of rows where atleast one cell is non-blank. How can I achieve it with array formulas?

For eg, in the above case, I have the second row all blanks, so my result would be 3 (3 rows have a value in atleast one cell)

Thank you in advance

 

[Canapone]

Hi,

a first approach:

=SUM(INDEX(--(COUNTIF(INDIRECT("A"&ROW(1:4)&":D"&ROW(1:4)),"<>")>0),0))

There are for sure better solutions to make it.

 

[Aladin Akyurek]

Let A2:D5 house the sample.

Control+shift+enter, not just enter:

=SUM(IF(MMULT(ISNUMBER(SEARCH("?",$A$2:$D$5))+0,TRANSPOSE(COLUMN($A$2:$D$5)^0)),1))