View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MyVeryOwnSelf[_3_] MyVeryOwnSelf[_3_] is offline
external usenet poster
 
Posts: 56
Default How to write a formula to get the maximum Amount of differentTEAM directly

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 dont know how to write F7 formula


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