COUNTIFS Formula not picking up additional rows


I created a COUNTIFS Formula to tabulate results from a column containing responses from a Multi Select Drop Down Form. Once I go the formula right, it calculated correctly but as additional rows have come in to the sheet, it isn't picking up those additional rows. One cell is still showing the original value, though based on my manual count the result is more than twice that number.

Any ideas.

Here's the formula: =COUNTIFS([Potential Training Topics]:[Potential Training Topics], HAS(@cell, "Builds Effective Teams: Behavior Based Interviewing"))



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!