Using the SUMIF function and structured references to display the total wins for teams in the Youth league is gotten as; 65
How to make use of the SUMIF Function?
The SUMIF function in excel combines a condition and a sum of the values which meets the stated condition. That is; SUMIF(row_range, condition)
From the attached image we can see the number of times youth won the league in column D. Also, we can see the total number of youth wins in column H under Total.
Thus, using SUMIF function for the total number of wins, we have;
B6 = SUMIF(SwimTeams[League], "youth",H3:H12
B6 = 21 + 16 + 12 + 9 + 7
B6 = 65
Read more about the SUMIF Function at; https://brainacademy.pro/question/19595606