Which formula should I use and is this even possible?
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.
Best Answer

If all of the columns are next to each other you could use
=COUNTIFS([First Column]@row:[Last Column]@row, "Yes")
Answers

If all of the columns are next to each other you could use
=COUNTIFS([First Column]@row:[Last Column]@row, "Yes")

That works. Thank you!

Happy to help. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!