View Single Post
  #1   Report Post  
wk3913 wk3913 is offline
Junior Member
 
Posts: 2
Default How to write a formula to get the maximum Amount of different TEAM 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 don’t know how to write F7 formula
Attached Images
 
Attached Files
File Type: zip Files.zip (8.1 KB, 10 views)

Last edited by wk3913 : August 24th 20 at 03:12 PM