How do I calculate the number of answers based on a specific value
Options
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
-
=COUNTIFS([Column1], "Male", [Column2], "Strongly Agree")
Answers
-
=COUNTIFS([Column1], "Male", [Column2], "Strongly Agree")
-
That's exactly what I was looking for! THANK YOU!
-
You are WELCOME! Have a wonderful day :)
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
