How to write a formula to get the maximum Amount of different TEAM directly
2 Attachment(s)
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 |
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) |
All times are GMT +1. The time now is 04:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com