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 it is just returning "#VALUE". Also, when I click on the formula he wrote to view it then press enter it returns "#VALUE" even though it was had the correct number before I clicked on it and pressed enter. 

Bellow are screenshots of my process: the correct total is displayed, I double click on the number to view the formula, I press enter and it returns "#VALUE"