Home |
Search |
Today's Posts |
#5
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
Merge cell & Copy Data from different cell | Excel Discussion (Misc queries) | |||
Cell Copy Error Message | Excel Discussion (Misc queries) | |||
Copy text from same cell on every sheet to title sheet? | Excel Discussion (Misc queries) | |||
copy contains from cell to cell w/ formula | Excel Worksheet Functions |