Hi

I don't follow what you mean, can you add your expected result. Look into the SUMIF/SUMIFS function and clean your text up in column A, on the tab: Material Cost for Each Project. To remove spaces.