Which formula should I use and is this even possible?

Michael Hair

I am trying to write a formula that will determine someone's risk level based off a number system. The risk level will either be 0, 1, or 2/3. I would like a formula that could take someone's answer to three "Yes" or "No" questions and add them together to show their risk level. The "No" would be worth 0 and the "Yes" would be worth 1. Is there a way I can make the Yes/No's worth those values and in turn add up using a formula in the "Risk Level" column? I could also change the Yes/No drop downs to a checkbox if that would be the only way for this to be possible.

Paul Newcome

If all of the columns are next to each other you could use

=COUNTIFS([First Column]@row:[Last Column]@row, "Yes")

Paul Newcome

If all of the columns are next to each other you could use

=COUNTIFS([First Column]@row:[Last Column]@row, "Yes")

Michael Hair

That works. Thank you!

Paul Newcome

Happy to help. 👍️