How remove a character ">" in order to SUM values in one column if they meet a criteria.

I need to be able to get the results using a formula. (I can't use a helper column, or the find and replace to remove ">".

Logic needed:

This formula should substitute the greater-than sign with nothing and convert those to numbers. Then it will need to sum the numbers where the criteria is met (in this case the condition will be the team). Then it need to divide that sum by a count for each team.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!