Formual to calculate highest point total summed by Name


Hello - Trying to return a name (Talent) with the highest total of points (Points Awarded) summed. So the points have to be summed by name (Talent) and return the name(Talent) with the highest points awarded totaled. I've started with this:

=SUMIF(Talent:Talent, Talent@row, [Points Awarded (Numbers Only)]:[Points Awarded (Numbers Only)])

Any help or suggestions are greatly appreciated - Thanks

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!