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

Mandy Campbell

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.

M Underbrink

=COUNTIFS([Column1], "Male", [Column2], "Strongly Agree")

M Underbrink

=COUNTIFS([Column1], "Male", [Column2], "Strongly Agree")

Mandy Campbell

That's exactly what I was looking for!  THANK YOU!

M Underbrink

You are WELCOME! Have a wonderful day :)