Either / Or but not both


Could someone help please?

I'd like to set a formula in a sheet with say 3 columns. It needs to sum/count depending on the answer of the first two columns but not them both. If either of the columms say "Yes" then that is good enough to be counted in the 3rd column.

For example:

Column A: Yes

Column B: Yes

Total: 1

Everyone formula I'm setting always gives either 0 or 2

Hopefully that makes sense.

Many thanks




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!