CountifS with Distinct

Options

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)

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!