Excel returning "#VALUE!" when I press enter after viewing the function.

I am trying to make a bill of materials that include price, quantity, and shipping cost. A teammate created a formula to add up the total cost and I am duplicating it for my part of the budget, but i...