I am trying to add 3 amounts. Right now the formula =SUM(D11:D12) 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(D11:D13) should be able to add
them all up, but no! I also tried =D11+D12+D13 and got the same result

Hi,

make sure Calculation is set to Automatic - choose Tools, Options,
Calculation, Automatic.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"FF/PM" wrote:

I am trying to add 3 amounts. Right now the formula =SUM(D11:D12) 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(D11:D13) should be able to add
them all up, but no! I also tried =D11+D12+D13 and got the same result

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.

"Shane Devenshire" wrote:

Hi,

make sure Calculation is set to Automatic - choose Tools, Options,
Calculation, Automatic.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"FF/PM" wrote:

I am trying to add 3 amounts. Right now the formula =SUM(D11:D12) 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(D11:D13) should be able to add
them all up, but no! I also tried =D11+D12+D13 and got the same result