Well, it slightly makes sense, but it sounds like a Sumifs would work. Instead of endless words and examples with no results, please attach an example workbook with what you have and the result you expect.