Newton Scientific Calculators

Customer Zone Model Volume $(000$ units$)$

Malaysia N$350399\mathrm{.}0$

China N$3503158\mathrm{.}3$

France N$3501406\mathrm{.}0$

Brazil N$350163\mathrm{.}5$

US Northeast N$35068\mathrm{.}7$

US Southeast N$350999\mathrm{.}7$

US Midwest N$350544\mathrm{.}9$

US West N$3501804\mathrm{.}0$

Malaysia N$450228\mathrm{.}0$

China N$450540\mathrm{.}9$

France N$450289\mathrm{.}8$

Brazil N$450240\mathrm{.}5$

US Northeast N$450313\mathrm{.}2$

US Southeast N$450681\mathrm{.}3$

US Midwest N$4501720\mathrm{.}3$

US West N$4502922\mathrm{.}3$

Malaysia N$9001301\mathrm{.}6$

China N$9001629\mathrm{.}3$

France N$9001790\mathrm{.}8$

Brazil N$900740\mathrm{.}7$

US Northeast N$90048\mathrm{.}3$

US Southeast N$9001522\mathrm{.}3$

US Midwest N$9002217\mathrm{.}5$

US West N$9001243\mathrm{.}6$ Newton Manufacturing produces scientific calculators. The models are N$350,$ N$450,$ and N$900.$ Newton has planned its distribution of these products around eight customer zones: Brazil, China, France, Malaysia, U$.$S$.$ Northeast, U$.$S$.$ Southeast, U$.$S$.$ Midwest, and U$.$S$.$ West. Data for the current quarter $($volume to be shipped in thousands of units$)$ for each product and each customer zone are given in the file Newton.xlsx$.$ Newton would like to know the total number of units going to each customer zone and also the total units of each product shipped. There are several ways to get this information from the data set. One way is to use the SUMIF function.

The SUMIF function extends the SUM function by allowing the user to add the values of cells meeting a logical condition. The general form of the function is

$=$SUMIF$($test range, condition, range to be summed$)$

The test range is an area to search to test the condition, and the range to be summed is the position of the data to be summed. So$,$ for example, using the file Newton, we use the following function to get the total units sent to Malaysia:

$=$SUMIF$($A$3$:A$26,$ A$3,$ C$3$:C$26)$

Cell A$3$ contains the text "Malaysia"; A$3$:A$26$ is the range of customer zones; and C$3$:C$26$ are the volumes for each product for these customer zones. The SUMIF looks for matches of "Malaysia" in column A and, if a match is found, adds the volume to the total. Use the SUMIF function to get total volume $(000$ units$)$ by each zone and total volume $(000$ units$)$ by each product.

Malaysia

China

France

Brazil

U$.$S$.$ Northeast

U$.$S$.$ Southeast

U$.$S$.$ Midwest

U$.$S$.$ West

N$350$

N$450$

N$900$