The best way to get this working natively that I’ve found is to use regex. For example, trying to count all occurrences of Active. It requires , and 1 to not be a part of the text. I only tested this with a Rollup.
Formatted to read it easier:
LEN(
...
