Count Responses for the Same Answer, for Multiple Persons

I created a survey and used the following formula to count repsonses; =COUNTIFS({2020 IS Employee Engagement Survey Range 3}, "Vin Miliano", {2020 IS Employee Engagement Survey Range 1}, "4 - Agree")

The formula works fine for Vin, as his number of responses is 2. I also have another user, Tim, and his response is 2. How do i extend my formula to count both names so that total is 4?

This request is so that a Director can have a roll-up score for their team!

Find more posts tagged with

Sheets

Formulas

Comments

Paul Newcome

You could add them together.

=COUNTIFS(.........) + COUNTIFS(.............)

Derrick Ward

Thanks! That worked!!😎

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.