View Single Post
  #1   Report Post  
Dave Peterson
 
Posts: n/a
Default

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