View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FF/PM FF/PM is offline
external usenet poster
 
Posts: 1
Default Stumped on adding 3 cells

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