Using Only the "SUMIF" Function, Complete the "Team Sales

question 5

Essay

Using only the "SUMIF" function, complete the "Team Sales."
​
​ $$\begin{array}{l}\text { Individual Sales }\\\begin{array} { | l | l | l | l | } \hline \text { Rank } & \text { Name } & \text { Sales } & \text { Team } \\\hline 1 & & & \\\hline 2 & & & \\\hline 3 & & & \\\hline 4 & & & \\\hline 5 & & & \\\hline 6 & & & \\\hline 7 & & & \\\hline 8 & & & \\\hline 9 & & & \\\hline 10 & & & \\\hline\end{array}\end{array}$$

---

Definitions:

Diminished Capacity

A reduction in an individual's ability to form intent or understand the consequences of their actions, often considered in legal contexts regarding accountability.

Extenuating Circumstance

A situation or condition that provides partial justification or explanation for an individual's behavior, potentially lessening the severity of a punishment or judgment.

Drug Therapy

The treatment of illness or disease with drugs or medications, designed to ameliorate symptoms or cure the condition.

Mental Hospitals

Health care facilities specializing in the treatment and care of individuals with mental disorders.