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
Last edited by wk3913 : August 24th 20 at 03:12 PM
|