Count Based on other Distinct Data

em_sfcc ✭✭
edited 07/01/20 in Formulas and Functions

I am doing end of year summary data and am stuck. I ran a report and have lots of data - name, gender, race from rosters across multiple trainings. There is duplicate data (X individual may have attended Y training, but also Z training). I need duplicated summary data - X counts as 1 person trained, 1 female trained, etc. Easy enough for names - I used COUNT(DISTINCT). But I am stuck on gender/race. I want to count unduplicaed males, and unduplicated females, etc. If this can be done using COUNTIFS, I haven't figured it out. Any suggestions?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!