13. In cell B16, use the SUMIF function and structured references to display the total wins for teams in the Youth league.
Expert-verified answer
0 (0 stars)
0
AFOKE88 1 year ago
746 response - 0 helps

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

Still have questions?