I have been searching the boards and am not coming up with what I want so I am hoping someone can point me in the right direction.

I have a sheet with a multi-select column. In the column you can select:



A, B

I want to find the 3 formulas that will count the number of times A shows up by itself, the number of times B shows up by itself, and the number of times that A, B show up together. Every time I try it keeps counting all of the times, for example, A shows up whether it be by itself or with another.

Thank you so much!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!