Forum Discussion
Counting how many rows have a specific text choice, but counting it only once
Hello Community. I was wondering if there was a function in Excel that can help me with the current issue: Instead of counting how many "yes" responses there are in the file, I wis...
Basically applying same principle as previous answer, you can also put the helper column formula as
=IF(COUNTIF(B2:Z2,"Yes")>0,1,0)
and drag it down.
Then SUM of this helper column is the desired result, i.e. rows with at least one "Yes".
=IF(COUNTIF(B2:Z2,"Yes")>0,1,0)
and drag it down.
Then SUM of this helper column is the desired result, i.e. rows with at least one "Yes".