Sum values in a column using a lookup function

I am trying to use a lookup function to sum the values in a column. The formula I am using now will only return the first matched value and is not summing all of the values with the lookup criteria. ...