or example, $=$FILTER$($Table$1,($Table$1[$Company$]=$"Stark Industries"$),"$No Results"$)$ is asking:

"Excel, go to Table$1,$ and then to the Company column. Next, find all the entries for Stark Industries and give me just those observations. you don't find anything, just retum No Results."

If you want fo filter on more than one column, you can use the multiplication $*$ symbol to have more than one include paramet FILTER. For example:

$=$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 Carver, Aubrey combined."

However, remember the data validation dropdowns you created in $31$ and $32?$ This is where the magic happens. Instead typing in company and customer manually, we can have the FILTER function reference $J1$ and $32$ instead. The FILTER function will then res 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 validation dropdown cells in J$1$ and $32.$ Have the function return $"$No Results" if no data is returned.

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

In cell $34,$ 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, Billie.

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

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

$