I have developed a formula that will sum column e from the A1 sheet that corresponds with the cell in column c of the total sheet if it matches the text located in column c of the A1 sheet. However, I can not get one to work for cell +C43 since it has several codes I am looking for. I would like to be able to sum all the values in column e on sheet A1 that corresponds with 733, 829, 834, or 854. I can get it to work if I ask for just one value. But if I ask for 733 or 829, it pulls a bad value.

I have attached the spreadsheet.

Thanks in advance for the help. I have spent two days trying to get it to work but to no prevail.

Melinda