Too long countifs statement

Hello all,

I have a problem with my countifs statement in that it is too long. All that I want to do is count how many rows do not have an NA value. The problem is that I want to do this with multiple columns. Attached is a sample of what I am talking about with my countifs statement. I think a sumproduct formula would work here, but I can't seem to figure it out. Any help would be greatly appreciated. Thanks.

Is this just an example - how many columns do you need to check?

Thanks for the reply. There are 20 columns with about 14,000 rows of data. I am trying figure out which rows are labeled "Test" but have a value for each column (thus if they have an "NA" anywhere in that row, I do not want to count this row). Also, there could be other non numeric values in the row and if that is the case, I would like to throw out these rows and not include it in my count.

OK so say you have column A which says "Test" or not and columns B to U which have numbers/"N/A" or other text, and you want to count only those rows which have "test" in column A and 20 numbers in B to U.

Simplest way might be to use an extra column, i.e. in V2 copied down

=(A2="Test")*(COUNT(B2:U2)=20)

Now just sum that column, i.e.

=SUM(V2:V14000)

alternatively, without a helper column try

=SUMPRODUCT((SUBTOTAL(2,OFFSET(B2:U2,ROW(B2:U14000)-ROW(B2),0))=COLUMNS(B2:U2))*(A2:A14000="test"))