Leaderboard Formula struggles



I feel like this is an obvious question but I can't seem to figure this out. I'm wanting to create a leaderboard to count how many miles people have competed in a competition. I have created a column with emails with a countif formula to count how many times this email has appeared in our entries but now want to create a new column that says "Count how many miles were completed if this email appears" and I am unsure how to?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!