LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I copy data in single cell format to a merged cell format Paul Excel Discussion (Misc queries) 1 June 27th 05 11:00 AM
Merge cell & Copy Data from different cell MK Excel Discussion (Misc queries) 0 June 24th 05 10:54 AM
Cell Copy Error Message gswan Excel Discussion (Misc queries) 0 March 15th 05 10:07 PM
Copy text from same cell on every sheet to title sheet? Jon Excel Discussion (Misc queries) 2 February 9th 05 03:11 PM
copy contains from cell to cell w/ formula randy Excel Worksheet Functions 1 December 1st 04 08:13 PM


All times are GMT +1. The time now is 11:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"