查找与引用单元格相关的值并对它们进行汇总

I have been playing around with excel for a bit now and I am trying to create a way to look up a text value in another table and add up all the numeric values that are associated with it.I have been playing around with excel for a bit