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 the attached doc for the result I need (column in black is my desired result).
Thanks!
That could be
=IF(SUM(COUNTIFS($B3:$M3,{"Retained","Expanded","Accessed"})),"Yes","No")and
=--(SUM(COUNTIFS($B3:$M3,{"Retained","Expanded","Accessed"}))>0)
2 Replies
Hi AL789
Please find below solution formula for your query.
=IF(SUMPRODUCT(--(B3:M3={"Retained";"Expanded";"Accessed"}))<1,"No","Yes")Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
That could be
=IF(SUM(COUNTIFS($B3:$M3,{"Retained","Expanded","Accessed"})),"Yes","No")and
=--(SUM(COUNTIFS($B3:$M3,{"Retained","Expanded","Accessed"}))>0)
