Suppose a company supplies four of its products A, B, C, and D, to five different regions. The management wants to know the total number of all products supplied to each region as well as the total number of units of each product supplied. The data collected over a period of month are given below.

\begin{array} { | c | c | c | } \hline \text { Region } & \text { Model } & \begin{array} { c } \text { Number of } \\\text { units }\end{array} \\\hline \text { Region 1 } & \text { A } & 1,784 \\\hline \text { Region 2 } & \text { A } & 2,170 \\\hline \text { Region 3 } & \text { A } & 415 \\\hline \text { Region 4 } & \text { A } & 2,040 \\\hline \text { Region 5 } & \text { A } & 2,991 \\\hline \text { Region 1 } & \text { B } & 947 \\\hline \text { Region 2 } & \text { B } & 2,111 \\\hline \text { Region 3 } & \text { B } & 1,234 \\\hline \text { Region 4 } & \text { B } & 2,061 \\\hline \text { Region 5 } & \text { B } & 607 \\\hline \text { Region 1 } & \text { C } & 2,907 \\\hline \text { Region 2 } & \text { C } & 4,790 \\\hline \text { Region 3 } & \text { C } & 2,191 \\\hline \text { Region 4 } & \text { C } & 1,942 \\\hline \text { Region 5 } & \text { C } & 220 \\\hline \text { Region 1 } & \text { D } & 2,557 \\\hline \text { Region 2 } & \text { D } & 2,980 \\\hline \text { Region 3 } & \text { D } & 1,518 \\\hline \text { Region 4 } & \text { D } & 2,957 \\\hline \text { Region 5 } & \text { D } & 4,462 \\\hline\end{array}

Display your use of the SUMIF function and find the total volume by each region and total volume by each product.

Navigation in a Spreadsheet Model Can Be Facilitated by

Multiple Choice

Correct Answer:VerifiedUnlock this answer nowGet Access to more Verified Answers free of chargeAccess For Free

Correct Answer:
Verified
Unlock this answer now
Get Access to more Verified Answers free of charge