View Single Post
  #5   Report Post  
Fred
 
Posts: n/a
Default

Point of information:

Strictly speaking your formula is incorrect, =D34+D35 would give you the
same answer. SUM() is intended for ranges eg =SUM(A1:A199). As mentioned
elsewhere if you want to copy this formula anywhere in the spreadsheet but
still sum the same values you must use absolute addresses.

"CShannon" wrote:

I have a formula such as "=sum(d34+d35)", I decided to move the location, but
when I move the location the formula is now "=sum(d31+d31). I would like to
move the first formula anywhere on the spreadsheet w/o it being changed. How
do you do that? Is it an absolute value or something like that?