Forum Discussion
Solved
Formula to count a row as 1 if any of the cells meet any of my 3 criteria
Hi everyone. I need a formula to count a row as "Yes" or a 1 if any of my 3 criteria are met. COUNTIF adds them up, but I only want the cells counted once so I can't use that formula. See th...
That could be
=IF(SUM(COUNTIFS($B3:$M3,{"Retained","Expanded","Accessed"})),"Yes","No")and
=--(SUM(COUNTIFS($B3:$M3,{"Retained","Expanded","Accessed"}))>0)
That could be
=IF(SUM(COUNTIFS($B3:$M3,{"Retained","Expanded","Accessed"})),"Yes","No")and
=--(SUM(COUNTIFS($B3:$M3,{"Retained","Expanded","Accessed"}))>0)