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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!