Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Turn a "Y" or "N" answer into a number

I want to have a cell where the user puts in a Y or N answer but have a formula see it as a 1 or a 0. Three columns will be yes or No answers then the final column will add them up and give a score. How do I allow a person to put in a Y or N and still have my formula assign a "1" or "0" to the answer then add them up? Thanks hope Im clear.

itunes-OTHER, Mac OS X (10.7.1)

Posted on Sep 1, 2018 3:40 PM

Reply
Question marked as Best reply

Posted on Sep 1, 2018 4:13 PM

if the "Y" and "N" values are in column B, then you can count the "Y"s in the column using the formula:

=countif(B, "Y")


you can count the "N"s using the formula:

=countif(B, "N")

2 replies

Turn a "Y" or "N" answer into a number

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.