In cell I$7,$ construct a FILTER function that references Table$1$ and will return data that has been filtered on the two data validation dropdown cells in J$1$ and J$2.$ Have the function return $"$No Results" if no data is returned.

In cell J$3,$ create a simple SUM function that will add up all the sales returned in column K$.$

In cell J$4,$ create a simple COUNT function that will tally the number of records returned. Hint: Use column K for this also.

Using the data validation dropdown cells, return all data where Acme Corporation sold to Williamson, Sidney.

How many records were returned? $($Enter zero for No Results.$)$

What was the total sales returned? $($Enter zero for No Results.$)$

$