Make another table with all the unique values of material then use a sumif equation. If you attach your sample excel file, rather than a picture, I can show you easily.