Sum of the Maximum Scores per Team

I ran into a problem that must have a better answer than what I came up with.

We had a golf tournament last weekend and each player played two rounds of golf. We played Stableford so the bigger number is better. We had 10 players on each team.

We took the better score of each player between the two days for their team score. Which team won?

See the attached where I did a Pivot to show the Max of each players score but then wanted to sum the maximums. I ended up doing a running total to get the team scores.

There must be an easier/better way.

Hi Marvin,

No file attached...

Check again.

Yep, just saw it...
Only non VBA solution I can come up with is by using a helper column...

Although I like the solution of GC Excel, I would just go for the pivot table.

Pivot table are made for this kind of work.

To my opinion it is the easied / best way.