Count Distinct Values that only appear multiple times
I have a formula that follows this structure
=count(distinct(collect(range, crit_range1, crit1, etc)))
that allows me to count the number of unique entries that meet a set of criteria. Now I'm trying to modify that formula that allows me to count the number of repeat entries that meet a set of criteria.
In the original formula, I'd get a result of 4 (assuming this list met all the criteria). With the new formula that I'm asking for help with, I'd get a result of 2 (John and James show up multiple times on the list).
Help Article Resources
Check out the Formula Handbook template!