Hi

Try the following in B2 on the "Material Cost for Each Project" tab and copy down.

=SUMIF('Daily Material Purchase'!$A$2:$A$20,$A2,'Daily Material Purchase'!$C$2:$C$20)

Also you need to clean up the text in column A on the "Daily Material Purchase" tab to remove unwanted spaces. Is this what you require!