Formula to sum and exclude

Hi, I am trying to create a formula that will look up customer name and amount from one sheet and match it the customer name on a different sheet. I would like it to also not include customers that ...