How do I calculate the number of answers based on a specific value

I'm trying to calculate the number of answers in one column but only want the ones that match up with a specific description in another column. For example, I want to count all of the males (column one) that answered "Strongly Agree" in column 2. How do I do this?

Thank you.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!