SUM formula

Morning all!

I'm looking for a formula that counts the total score from my team summary, as long as the team name matches

and populate it here, where it will then rank their score in comparison to other teams

I have tried a number of SUM formulas, and cant get one to work for me. Any suggestions?

Thanks in advance!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!