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