1. Forum
  2. Usenet
  3. MSOFT.PUB.EXCEL.WORKSHEET

  • How to write a formula to get the maximum Amount of different TEAM

    From MyVeryOwnSelf@21:1/5 to All on Mon Aug 24 11:13:20 2020
    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)