Excel Filter Not Filtering Correctly

Hi,   I am trying to collect some data for a project off of my table in excel. When I go filter a certain cateogory, it doesn't work. Example, filtering vendors and I would like to see how much eac...