Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Absolute Values and Column Insertions
I've created a formula in column A that adds up some cells in column D. Ex:
=sum(D3:D6). If I insert one column in front of column D, the formula changes to =sum(E3:E6). This happens even if I change the formula to =sum($D$3:$D$6). I also tried creating a range name called TEST referring to the original $D$3:$D$6 range and the column insertion changed the TEST range definition as well. Is there a way to keep a formula from NOT adjusting to column insertions or deletions? Thanks in advance! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Absolute Values and Column Insertions
Please don't multi-post
See answer in other newsgroup -- Kind regards, Niek Otten Microsoft MVP - Excel "BobK" wrote in message ... I've created a formula in column A that adds up some cells in column D. Ex: =sum(D3:D6). If I insert one column in front of column D, the formula changes to =sum(E3:E6). This happens even if I change the formula to =sum($D$3:$D$6). I also tried creating a range name called TEST referring to the original $D$3:$D$6 range and the column insertion changed the TEST range definition as well. Is there a way to keep a formula from NOT adjusting to column insertions or deletions? Thanks in advance! |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Absolute Values and Column Insertions
BobK;229671 Wrote: I've created a formula in column A that adds up some cells in column D. Ex: =sum(D3:D6). If I insert one column in front of column D, the formula changes to =sum(E3:E6). This happens even if I change the formula to =sum($D$3:$D$6). I also tried creating a range name called TEST referring to the original $D$3:$D$6 range and the column insertion changed the TEST range definition as well. Is there a way to keep a formula from NOT adjusting to column insertions or deletions? Thanks in advance! Hi, try =sum(indirect("d3:d6")) -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=64156 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Absolute Values and Column Insertions
Sorry Niek:
I got a MS error saying that it didn't post, so I recreated. "Niek Otten" wrote: Please don't multi-post See answer in other newsgroup -- Kind regards, Niek Otten Microsoft MVP - Excel "BobK" wrote in message ... I've created a formula in column A that adds up some cells in column D. Ex: =sum(D3:D6). If I insert one column in front of column D, the formula changes to =sum(E3:E6). This happens even if I change the formula to =sum($D$3:$D$6). I also tried creating a range name called TEST referring to the original $D$3:$D$6 range and the column insertion changed the TEST range definition as well. Is there a way to keep a formula from NOT adjusting to column insertions or deletions? Thanks in advance! |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Absolute Values and Column Insertions
You're not alone! Something is wrong with this forum
-- Kind regards, Niek Otten Microsoft MVP - Excel "BobK" wrote in message ... Sorry Niek: I got a MS error saying that it didn't post, so I recreated. "Niek Otten" wrote: Please don't multi-post See answer in other newsgroup -- Kind regards, Niek Otten Microsoft MVP - Excel "BobK" wrote in message ... I've created a formula in column A that adds up some cells in column D. Ex: =sum(D3:D6). If I insert one column in front of column D, the formula changes to =sum(E3:E6). This happens even if I change the formula to =sum($D$3:$D$6). I also tried creating a range name called TEST referring to the original $D$3:$D$6 range and the column insertion changed the TEST range definition as well. Is there a way to keep a formula from NOT adjusting to column insertions or deletions? Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Absolute Values and Column Insertions | Excel Discussion (Misc queries) | |||
#Value Problem - Inconsistent Formulas After Column Insertions | Excel Worksheet Functions | |||
Summing a Column - Net and Absolute Values | Excel Worksheet Functions | |||
sum absolute values of a column of numbers in Excel | Excel Worksheet Functions | |||
Absolute Values | Excel Worksheet Functions |