ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to write a formula to get the maximum Amount of different TEAM directly (https://www.excelbanter.com/excel-worksheet-functions/454925-how-write-formula-get-maximum-amount-different-team-directly.html)

wk3913

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

MyVeryOwnSelf[_3_]

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