Counting specific values in a column

Hi, This should be easy...

I am trying to sum up the number of single rooms and the number of double rooms and I can't get it to work.

I just want it to count how many "SGL" and separately how many "DBL"

Any advice?

Thank you.


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!