New answers tagged

2

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"), ...


1

Try =IF( AND( ArrayFormula( FILTER( {Failed!M2:M,Failed!O2:O,Failed!T2:U,Failed!W2:X,Failed!Z2:AC}, LEN(Failed!A2:A) ) = "No, I do not have psoriasis on this area" ) ), 1, 0 )



Top 50 recent answers are included