Enter a SUMIFS function in cell D$11$ on the Summary worksheet that sums the

sales this year by store size for the region number entered into cell B$9.$ Define

the $[$Sum$\_$range$]$ argument with the range I$4$:I$40$ on the Sales and Inventory

worksheet. Define the $$criteria$\_$range$1$ argument with the range A$4$:A$40$ on the

Sales and Inventory worksheet and the $$criteria$1$ argument with cell B$9$ on the

Summary worksheet. Define the $[$criteria$\_$range$2]$ argument with the range

F$4$:F$40$ on the Sales and Inventory worksheet and the $[$criteria$2]$ argument with

cell B$11$ on the Summary worksheet. Place absolute references on cell B$9$ in the

$$criteria$1$ argument and all three cell ranges used in the function.