I need cell B21
in the Reports
sheet to add up all rows that meet this criterion:
return a value of
1
if columns M, O, T, U, W, X, Z, AA, AB, AC have the answerNo, I do not have psoriasis on this area
in theFailed
worksheet.
The formula I currently have only applies to row 2.
=IF( COUNTIF( ARRAYFORMULA( {Failed!M2,Failed!O2,Failed!T2:U2,Failed!W2:X2,Failed!Z2:AC2} ), "No, I do not have psoriasis on this area" )=10, 1, 0 )
How do I sum up all rows?