Create a summary sheet with an input cell that allows a user to indicate a supplier. You decide where to put this, but make it an obvious input cell. Display how many items are provided by the selected supplier.
Show the average "Lastname Cost" for ONLY the items provided by the selected supplier.
Create four labels representing each of the four shipping types. NOTE: Your first name is now a shipping type instead of “Optional.”.