Excel now has a FILTER function that can be utilized to create dynamic tables that builds upon this filtering functional Consider this instruction: "Excel, go over to my data table and get me just the sales data for Stark Industries where data validation dropdowns in $J1$ and $J2.$

FILTER works almost exactly like the instruction above. You tell FILTER where to look to find the data $($array$),$ direct it $=$ FILTER$($array$,$ include, $[$if$\_$empty$])$

For 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 obse If you want to filter on more than one column, you can use the multiplication $*$ symbol to have more than one include $=$FILTER$($Table$1,($Table$1[$Company$]=$"Stark Industries"$)*($Table$1[$Customer$]=$ "Carver, Aubrey"$),"$No Result This is the equivalent of an AND statement. "Give me all observations where the company is Stark Industries AND the However, remember the data validation dropdowns you created in $J1$ and $J2?$ This is where the magic happens. Insteac In cell I$7,$ construct a FILTER function that references Table$1$ and will return data that has been filtered on the two data In cell J$3,$ create a simple SUM function that will add up all the sales returned in column $K.$ In cell $J4,$ create a simple COUNT function that will tally the number of records returned. Hint: Use column $K$ for this als Using the data validation dropdown cells, return all data where Nakatomi Corp sold to Hughes, Jody.

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