Count rows, which have not blank cells-CodePudding

COUNTIF(range,"<>") function allows us to count cells, which are not blank. But how to count rows, which are not blank?

I have a range A1:C100, some cells in this range are blank and some are not blank. I want to count a row when and only when it has at least one non blank cell in one of the tree columns.

P.S. I'm using googledocs.

CodePudding user response：

If you have Office 365:

=SUM(N(MMULT(N(range<>""),SEQUENCE(COLUMNS(range))^0)>0))

Otherwise, array formula (CTRL SHIFT ENTER):

=SUM(N(MMULT(N(range<>""),TRANSPOSE(COLUMN(range))^0)>0))

CodePudding user response：

In GS you could alternatively try:

=INDEX(SUM(N(TRIM(QUERY(TRANSPOSE(A1:C100),,9^9))<>"")))