$=$FILTER$($Table$1,($Table$1[$Company$]=$"Stark Industries"$)*($Table$1[$Customer$]=$"Carver, Aubrey"$),"$No Results"$)$

This is the equivalent of an AND statement. "Give me all observations where the company is Stark Industries AND the customer

However, remember the data validation dropdowns you created in J$1$ and J$2?$ This is where the magic happens. Instead typing in FILTER function will then respond to changes in those dropdowns creating a dynamic table.

In cell I$7,$ construct a FILTER function that references Table$1$ and will return data that has been filtered on the two data validatio In cell $13,$ 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 Umbrella Corporation sold to Doyle, Binlie.

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

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