Max & Min For team Name by Sum Total Points

[Hany ali]

Hi my Dear i Want Your Help to get the name of Team whose have max and Min sum Points from column A & B AS you see in photo

 

[Hany ali]

Good evening to all our distinguished professors, there is no solution to this request

 

[rahulshewale1]

hi @Hany ali ,

Please give detail from where value coming ( Points = 12, Team Name = Real betis, Sum MAX/ Min Points

 

[Hany ali]

thanks for you mr.
rahulshewale1 for feedback
this Points from max Total Points From Column A By Team Name from Column F + max Total Points From Column B By Team Name from Column I .....I hope every think is clear Now
thanks alot one time more

 

[Peter Bartholomew]

Do you have access to Microsoft 365? If so a solution could be

= LET( comma, ", ",
   sumHomePts, SUMIFS(HomePts,HomeTeam,Team),
   sumAwayPts, SUMIFS(AwayPts,AwayTeam,Team),
   points, sumHomePts + sumAwayPts,
   max, MAX(points),
   min, MIN(points),
   topTeam, TEXTJOIN(comma,,FILTER(Team, points=max)),
   bottomTeam, TEXTJOIN(comma,,FILTER(Team, points=min)),
   CHOOSE({1,2;3,4}, topTeam, max, bottomTeam, min) )

The formula gives both top and bottom team and their total points in one formula. It also caters for multiple top or bottom placed teams.

Without 365, you would need helper ranges and a separate formula for each result cell.

p.s. I found it strange working with English text, the Spanish League and Arabic sheet layout!

 

[Peter Bartholomew]

The workbook

 

[Hany ali]

thanks alot Perfect answer but if Possible Normal Functions ... because I haven't Office 365 ,I have microsoft office 2010

 

[Peter Bartholomew]

Calculate the terms separately and instead of FILTER use INDEX/MATCH, e.g.
= INDEX(Team, MATCH(MAX(Points), Points,0))
The calculation is based upon the helper range in which all the point totals are listed.

I am not the best person on this forum to help because I avoid traditional spreadsheet approaches.

 

[Peter Bartholomew]

Apologies. The workbook a #6 shows the formula as ={#VALUE!} despite the result appearing correct. I hadn't noticed that the file was an .xls. Hopefully this .xlsx sheet will retain the 365 formulas as well as some more standard formulas.

 

[Hany ali]

Thank you very much for your honor

 

[herofox]

hello ....it's another Solution