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"))
Bookmarks