2. Sunflower Bakery maintains a list of five suppliers from whom they purchase all their baking supplies for their stores in four regions. You want to know at the end of the year how much Sunflower Bakery has purchased from each supplier, and the average amount of purchase in each of the four regions. You have extracted a list of transactions in 2014, supplier, purchase amount ($), and region (see worksheet q2). These are shown in the four columns in the cells A2:D21 (not all data are visible).

[SUMIF function] Write a formula in cell G3 in a way that it can be copyandpasted across G4:G7. The formulas for cells G3G7 are supposed to show the total amounts purchased from supplier listed in F3 F7. Note that your formulas must still work even if the values in F3:F7 are randomly swapped.

[AVERAGEIF function] Write a formula in cell G10 in a way that it can be copyandpasted across G11:G13. The formulas for cells G10G13 are supposed to show the average amounts purchased in regions listed in F10F13. Note that your formulas must still work even if the values in F10F13 are randomly swapped.

Sunflower Bakery - Baking Supplies Purchases in 2014 Invoice ID Supplier Amount $ $237.76 S631.10 $428.82 $800.58 $340.21 S100.48 $809.83 S953.02 S301.60 $72.50 $876.14 $589.25 S610.59 $445.86 S513.80 $903.85 $658.63 $341.25 $844.82 Region South North East West East North South South West West North South East West East North South North West Supplier Total Amount $ SBP2014-123 SBP2014-124 SBP2014-125 SBP2014-126 SBP2014-127 SBP2014-128 SBP2014-129 SBP2014-130 SBP2014-131 SBP2014-132 SBP2014-133 SBP2014-134 SBP2014-135 SBP2014-136 SBP2014-137 SBP2014-138 SBP2014-139 SBP2014-140 SBP2014-141 Bakery Crafts Baker's Kitchen Bakery Crafts Creative Baking Cake Supplies Gourmet Baking Gourmet Baking Bakery Crafts Bakery Crafts Gourmet Baking Baker's Kitchen Gourmet Baking Baker's Kitchen Bakery Crafts Baker's Kitchen Bakery Crafts Creative Baking Gourmet Baking Baker's Kitchen Bakery Crafts Baker's Kitchen Cake Supplies Creative Baking Gourmet Baking Region Average Amount S North South East West