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

question 57

Essay

Using only "SUMIF", complete the "Team Sales".
​ $$\begin{array} { | l | l | l | l | } \hline& { \text { Individual Sales } } \\\hline \text { Rank } & \text { Name } & \text { Sales } & \text { Team } \\\hline 6 & \text { Susan } & 5 & \text { red } \\\hline 8 & \text { Thomas } & 7 & \text { red } \\\hline 9 & \text { Lynn } & 2 & \text { blue } \\\hline 5 & \text { Sean } & 6 & \text { blue } \\\hline 1 & \text { Jerry } & 20 & \text { yellow } \\\hline 2 & \text { George } & 12 & \text { red } \\\hline 10 & \text { Elaine } & 1 & \text { red } \\\hline 7 & \text { Delores } & 4 & \text { blue } \\\hline 4 & \text { Tony } & 9 & \text { yellow } \\\hline 3 & \text { Art } & 12 & \text { blue } \\\hline\end{array}$$ ​ $$\begin{array} { | l | l | l | l | } \hline & { \text { Individual Sales } } \\\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}$$

---

Definitions:

Respiratory status

The current health and functioning level of the respiratory system, assessing aspects like breathing rate and oxygen levels.

Neurological function

The operations and activities of the nervous system, including cognitive processes and physical responses.

Neonate

Stage of life from birth to 1 month of age.

Sleep requirements

refers to the amount of sleep needed to function optimally, which can vary by age, lifestyle, and health status.