Using the COUNTIFS to determine quantity for feedback



I am trying to determine a count of a Theme and Sub-Theme but do not seem to be able to since the Sub-Theme column is a multi-select dropdown. Any advice on how to do this?

Currently, I am using the following formula: =COUNTIFS({Range 1}, "Theme Name", {Range 2}, "Sub-Theme Name"))

The only time the formula is calculating the correct # is when there is only 1 selection for the sub-theme. When there are multiple, it does not calculate anything.

Any advice when calculating 2 ranges, with one being a multi-select drop down?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!