13. In cell B16, use the SUMIF function and structured references to display the total wins for teams in the Youth league.
1 answer:
Using the SUMIF function and structured references to display the total wins for teams in the Youth league is gotten as; 65
<h3>How to make use of the SUMIF Function?</h3>
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; brainly.com/question/19595606
You might be interested in
Answer:
I've implemented this program using python
userinput = int(input("Length: "))
mylist = []
mylist.append(userinput)
for i in range(1,userinput+1):
userinp = int(input("Input: "))
mylist.append(userinp)
smallval = mylist[1]
for i in range(1,len(mylist)):
if smallval > mylist[i]:
smallval = mylist[i]
for i in range(1,len(mylist)):
mylist[i] = mylist[i] - smallval
for i in range(1,len(mylist)):
print(mylist[i],end=' ')
Explanation:
I've added the full source program as an attachment where I used comments to explain difficult lines
