This box allows you to filter and sort the table, in this case, on the Customer variable. Let's see how it works. combination." Sounds like something very useful in a business context, right? We can achieve this using the FLITER function and our data validation dropdowns in $J1$ and $32.$ returns nothing $($if empty$).$ The syntax looks like this:

$=$FILTER$($array$,$ include, $[$if$\_$empty$])$

For example, $=$FILTER$($Table$1,($Table$1[$Company$]=$"Stack 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 givo mo just those observations. If you don't find anything, just return No Results."

If you want to filter on more than one column, you can use the multiplication $*$ symbol to have more than one include parameter in 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. "Glve me all observations where the company is Stark Industries AND the customer is Carver, Aubrey combined." The FILTER function will then respond to changes in those dropdowns creating a dynamic table.

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 Globex Corporation 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.$)$

$