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:

Orbicularis Oris

A muscle around the mouth that allows the lips to close or pucker.

Puckers Mouth

The action of contracting the muscles around the mouth, often resulting in a wrinkled or protruded appearance.

Trapezius Muscle

A large superficial muscle that extends from the occipital bone to the lower thoracic vertebrae and to the scapula, involved in moving, rotating, and stabilizing the scapula and extending the neck.

Laterally Flex

To bend the body or a part of the body to the side.