Trying to use COUNTIFS to count Items in a drop-down column

I have a drop-down column for Issues and a column for Campuses, and I'm trying to count the number of times an issue shows up for each campus. The formula that I'm using is counting the issues, but only if it is the only item selected in the drop-down:

=COUNTIFS({Campus}, "Chico", {Issue}, "Unilateral Change")

Instead of retuning a count of 4, its counting only 3.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!