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 answer No, I do not have psoriasis on this area in the Failed  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?
Formula to use to add up all rows that returned a value of '1' for several cells that meet a specific criterion
google spreadsheets;formulas
This should work:=SUM(ArrayFormula(N({Failed!M2:M,Failed!O2:O,Failed!T2:U,Failed!W2:X,Failed!Z2:AC}=No, I do not have psoriasis on this area)))After some clarification this formula seems to have worked:=COUNTIF(ArrayFormula(MMULT(N({Failed!M2:M,Failed!O2:O,Failed!T2:U,Failed!W2:X,Failed!Z2:AC}=No, I do not have psoriasis on this area), transpose(split(rept(1+, 10),+)))), =10)