Formual to calculate highest point total summed by Name

julieg

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

Paul Newcome

You are going to want to insert a helper column to have the summed total on each row using the formula above.

From there you would use

=INDEX(Talent:Talent, MATCH(MAX([Helper Column]:[Helper Column]), [Helper Column]:[Helper Column], 0))

Paul Newcome

You are going to want to insert a helper column to have the summed total on each row using the formula above.

From there you would use

=INDEX(Talent:Talent, MATCH(MAX([Helper Column]:[Helper Column]), [Helper Column]:[Helper Column], 0))

julieg

Thank you Paul - That worked. It didn't occur to me to add a column with the summed total for each person. Thanks again.

Paul Newcome

Happy to help. 👍️