Your supervisor has requested an area on the spreadsheet that quickly summarizes sales over the past few months. In cell D$25,$ calculate the sum for the Hard Drive category that totals the three months results in D$6$:F$6.$ Use a similar formula in cells D$26$:D$29$ substituting the correct formula cell references for each product.

In cell E$25,$ create an IF function that will determine if sales goals have been met for each product listed. Return Goal Met if true, otherwise return Not Met. Copy the formula down to cell E$29.$

In cell I$8,$ enter the FILTER function to display the Monthly Snapshot data for those products that met their goal in Quarter $1.$