2 years ago

13. In cell B16, use the SUMIF function and structured references to display the total wins for teams in the Youth league.

1 answer:

8 0

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

Lime is using social media to ask consumers about the qualities they desire in an electric scooter. The firm hopes to develop a

tresset_1 [31]

Answer:

The correct answer to the following question will be "Product".

Explanation:

Product marketing is often a mechanism by which a brand is marketed and delivered to a client. It's also known as the intermediate feature between product innovation and brand recognition or awareness.
It's something to which comparison is made when selling a product on the market to the consumer.

Therefore, the Product is the right answer for the above question.

8 0

3 years ago

Which set of symbols encloses an if-then code block? Choose the best answer.

Colt1911 [192]

Here's some code that might help, assuming that you are using JavaScript.

e = "Hello"

if(e === "Hello"){

alert(":D")

}else{

console.log("Um.")

}