CountifS with Distinct


I need a function to count how many time a territory as unique SIDs in a sheet. I tried the function below but it won't work.

=COUNTIFS({Total URV Visits Range SID}, DISTINCT({Total URV Visits Range SID}), {Total URV Visits BEC}, District@row)


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!