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?
|