How do I copy a formula/paste w/o losing the cell content?

[Guest]

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?

 

[Anne Troy]

Yes. The formula must be written as =sum($d$34+$d$35)
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[RagDyer]

OR,
Select the entire formula in the formula bar,
Right click and choose "COPY",
Hit <Enter>,
And paste anywhere you wish.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[Ken Russell]

Moving changes the formula unless you make the references absolute as Anne
suggests.

There is another way. Cut and paste instead of copy and paste, but that
removes the formula from its original cell.

--
Ken Russell

(e-mail address removed)
Remove yourhat to reply by e-mail
..

 

[Guest]

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.

 

[Bob Phillips]

If you really mean move, you can drag it across as well which doesn't update
it.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Dave Peterson]

Or
=sum($d$34:$d$35)
or
=sum($d$34,$d$35)
or
=$d$34+$d$35

(I wouldn't use the + inside the =sum() function.)

But I bet your real point was about using absolute references.