Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 24th 20, 03:00 PM
Junior Member
 
First recorded activity by ExcelBanter: Aug 2020
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, 3 views)

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

  #2   Report Post  
Old August 24th 20, 07:13 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2012
Posts: 54
Default 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 don’t know how to write F7 formula


Maybe something like:
=MAX(A:A)+MAX(B:B)+MAX(C:C)


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set a maximum amount in a cell? Griffindor107 Excel Worksheet Functions 4 September 22nd 12 12:40 AM
Return Maximum from Column directly above Maximum in Row Code Numpty Charts and Charting in Excel 2 November 19th 08 08:29 AM
Maximum amount allowed Wannano Excel Discussion (Misc queries) 1 March 13th 07 08:25 PM
Maximum amount of characters in a footer Matt W. Excel Discussion (Misc queries) 4 February 23rd 06 10:15 PM
formula that includes a maximum amount fbcmusicmark Excel Worksheet Functions 5 December 7th 05 12:25 AM


All times are GMT +1. The time now is 03:32 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright ©2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017