Excel - total count of records where all 3 columns of data are blank

Question

I'm trying to create a formula that provides the total count of records in column A that either have a null or 0 across all 3 columns. Ex

Name    Score1 Score2 Score3
Test A
Test B           90
Test C
Test D.   0             0

In this example the total would be 3 because there are 3 Test that don't have a score entered.

**Most importantly it will need to be dynamic as the Row #'s can grow. Can I incorporate the count of non blanks in column A to let the formula know how far down to check?

I'm sure it's simple but none of my approaches are working. Thanks in advance!!

Answer 1

If all values are either blank or numeric (and >=0) only that would work:

=SUM(BYROW(B2:D7,LAMBDA(a,IF(SUM(a)=0,1,0))))

Adapt range B2:D7 according to yours.

UPDATE:

=SUM(BYROW(B2:D7,LAMBDA(a,IF(SUM(COUNTIF(a,{"0",""}))=COLUMNS(a),1,0))))

Will work with both text and negative values. It will count if all values in row are blank or 0 or any combination of it:

Answer 2

You can try the following:

=SUM(N(MMULT(N(B2:D5<>0), SEQUENCE(COLUMNS(B2:D5),,1,0))=0))

The condition: N(B2:D5<>0) serves to check cells that have a value different than zero and also non-blank cells.

Here using a shorter way to generate an array column of ones:

=SUM(N(MMULT(N(B2:D5<>0), TOCOL(N(B1:D1<>"")))=0))