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

However, remember the data validation dropdowns you created in $J1$ and $J2?$ This is where the magic happens. Instead typing in the company and customer manually, we can have the FILTER function reference $J1$ and $J2$ instead. The 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 validation dropdown cells in $J1$ and $32.$ 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 Initech sold to Hughes, Jody.

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

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

$

The FREQUENCY function

You can find more information about the FREQUENCY function at Office Support here.