Excel returning "#VALUE" for no apparent reason

[ctaylor17]

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"

 

 

 

[zeusthemoose]

I don’t think you can use SUM() and then put operands inside. Try “=(D18:D28*E18:E28)+F18:F28”

[Oshino Shinobu]

Press Ctrl+Shift Enter when entering that formula

[Oshino Shinobu]

9 minutes ago, zeusthemoose said:

I don’t think you can use SUM() and then put operands inside. Try “=(D18:D28*E18:E28)+F18:F28”

You can. You just need to use Ctrl+Shift Enter for array formulas

[ctaylor17]

Alright it's working now. Thanks guys