Team A max amount is 1812 + Team B max amount is 2080 + Team C max
amount is 4379

so F7 cell The Team SUM(MAX(A+B+C)) Final result is 8271

I don’t know how to write F7 formula

Maybe something like:
=MAX(A:A)+MAX(B:B)+MAX(C:C)

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)