Answer Happy

B Newton Scientific Calculators Customer Zone Model Malaysia N350 China N350 N350 N350 N350 N350 N350 N350 N450 N450 N450 A France Brazil US Northeast US Southeast US Midwest US West Malaysia China France Brazil US Northeast US Southeast US Midwest US West Malaysia China France Brazil US Northeast US Southeast US Midwest US West N450 N450 N450 N450 N450 N900 N900 N900 N900 N900 N900 N900 N900 с Volume (000 units) 399.0 3158.3 1406.0 163.5 68.7 999.7 544.9 1804.0 228.0 540.9 289.8 240.5 313.2 681.3 1720.3 2922.3 1301.6 1629.3 1790.8 740.7 48.3 1522.3 2217.5 1243.6 D
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 Newton file, we would use the following function to get the total units sent to Malaysia: =SUMIF (A3:A26, A3, C3:C26). Here, cell A3 contains the text "Malaysia", A3:A26 is the range of customer zones, and C3:C26 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 each total volume by zone and each total volume by product. (a) Complete the below table for total number of units distributed in each customer zone. If required, round your answers to one decimal place. Customer Zone Total Volume (000 units) Brazil China France Malaysia US Midwest US Northeast US Southeast US West Total 240.5 3158.3 1406 1301.6 1720.3 313.2 681.3 2922.3 11743.5