How to count DISTINCT countries within a date range?

Quarterly, I am required to show how many DISTINCT countries were reached by our instructors. I need a formula that would count the DISTINCT countries reached between (for example) 1/1/2020 thru 3/31/2020 (for first Quarter reporting). I've attached a snippet from my Smartsheet to show the setup.

I have the formula for counting DISTINCT countries, but I need to add the date range.

=COUNT(DISTINCT[LOCATION COUNTRY]1:[LOCATION COUNTRY]114))

Thank you for your help!!!

Kitty Sandel

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!