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}$$

Question

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}$$

Quizplus · Accepted Answer

The Answer of 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}$$

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