Stumped on adding 3 cells

[FF/PM]

I am trying to add 3 amounts. Right now the formula =SUM(D1112) works, but
when I try to add cell D13 to that it returns a 0.

D11 $8,000,000 number
D12 $870,000 number
D13 $22,598 formula: =(D58*$C13)/4
D14 $8,870,000 Trying to add all three numbers.

I can't figure this one out. Seems that SUM(D1113) should be able to add
them all up, but no! I also tried =D11+D12+D13 and got the same result

 

[Shane Devenshire]

Hi,

make sure Calculation is set to Automatic - choose Tools, Options,
Calculation, Automatic.

 

[FF/PM]

It was set to automatic.

I don't know if this makes a difference... I have it linked and embedded in
a word file... not this specific sheet, but a part of the same workbook.

The links seem to be working fine.