Click on the datafile logo to reference the data. DATA 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: 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(A3:A26,A3,C3:C26) (a) Complete the table below for the total number of units distributed to each customer zone. If required, round your answers to one decimal place. (b) Complete the table below for the total units of each product shipped. If required, round your answers to one decimal place. \begin{tabular}{|l||r|r|} \hline \multicolumn{2}{|l|}{ Newton Scientitic Calculators } \\ \hline Customer Zone & Model & Volume (000 units) \\ \hline Malaysia & N350 & 468.0 \\ \hline China & N350 & 3253.3 \\ \hline France & N350 & 1467.0 \\ \hline Brazil & N350 & 242.5 \\ \hline US Northeast & N350 & 160.7 \\ \hline US Southeast & N350 & 1013.7 \\ \hline US Midwest & N350 & 564.9 \\ \hline US West & N350 & 1845.0 \\ \hline Malaysia & N450 & 312.0 \\ \hline China & N450 & 572.9 \\ \hline France & N450 & 389.8 \\ \hline Brazil & N450 & 284.5 \\ \hline US Northeast & N450 & 346.2 \\ \hline US Southeast & N450 & 719.3 \\ \hline US Midwest & N450 & 1785.3 \\ \hline US West & N450 & 2962.3 \\ \hline Malaysia & N900 & 1359.6 \\ \hline China & N900 & 1658.3 \\ \hline France & N900 & 1805.8 \\ \hline Brazil & N900 & 776.7 \\ \hline US Northeast & N900 & 118.3 \\ \hline US Southeast & N900 & 1603.3 \\ \hline US Midwest & N900 & 2231.5 \\ \hline US West & N900 & 1296.6 \\ \hline \end{tabular}