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?

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

www.OfficeArticles.com
www.MyExpertsOnline.com


"CShannon" wrote in message
...
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?

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!
==============================================


"Anne Troy" wrote in message
news:29ed$42bcc1ba$97c5108d$28773@allthenewsgroups .com...
Yes. The formula must be written as =sum($d$34+$d$35)
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"CShannon" wrote in message
...
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?

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


Remove yourhat to reply by e-mail
..

"CShannon" wrote in message
...
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?

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?

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)


"RagDyer" wrote in message
...
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!
==============================================


"Anne Troy" wrote in message
news:29ed$42bcc1ba$97c5108d$28773@allthenewsgroups .com...
Yes. The formula must be written as =sum($d$34+$d$35)
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"CShannon" wrote in message
...
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?

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.


Anne Troy wrote:

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

www.OfficeArticles.com
www.MyExpertsOnline.com

"CShannon" wrote in message
...
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?

--

Dave Peterson