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 $J1$ and $J2.$ Have the function return $"$No Results" if no data is returned.

In cell $J3,$ 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 Soylent Corp sold to Murphy, Addison.

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

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