# Find max value of sumifs

#### mrblister

##### Board Regular
 A B C 1 Name Points Current Leader 2 Amy 10 Amy 3 Bob 5 Amy 4 Amy 2 Amy 5 Caleb 15 Caleb 6 Bob 10 Caleb 7 Bob 1 Bob 8 Amy 4 Bob 9 Bob 1 Bob 10 Amy 2 Amy

<tbody>
</tbody>

I'm trying to find a formula for column C, which outputs the person with the greatest accumulated score (accumulates moving down. E.g. C5 outputs the person with the highest score between rows 1 and 5). Notes:
• If there is a tie (e.g. C6, C8), column C returns the incumbent name (the name higher on the list) OR can display "Tie"
• I'd rather not use helper columns FOR NAMES if possible, as I have many names. But helper columns would be OK, just not for names.

Thanks!

### Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

#### Eric W

##### MrExcel MVP
Try this in C2:

=INDEX(\$A\$1:\$A2,MATCH(MAX(SUMIF(\$A\$1:\$A2,\$A\$1:\$A2,\$B\$1:\$B2)),SUMIF(\$A\$1:\$A2,\$A\$1:\$A2,\$B\$1:\$B2),0))

confirm with Control+Shift+Enter, then drag down as needed.

#### jtakw

##### Well-known Member
Hi,

Since it's accumulated scores going down column...

Use C2 formula copied down if you want to show "Tie" (Your sample row 6 where you show "Caleb" should be a Tie between Bob and Caleb ?)
Use D2 formula copied down if you Don't need to show "Tie", as in your posted sample.

Formulas normally entered:

Replies
4
Views
171
Replies
2
Views
29
Replies
5
Views
621
Replies
2
Views
24
Replies
3
Views
644