If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Relative vs. Absolute Values in Formulas
I understand the concept of absolute and relative
formulas. But what I can't seem to make happen is this scenario: A B C D E F 1 10 20 30 40 =d1 1/10/04 2 50 60 70 80 =if(f2=f1,e1+d2,d2) 1/10/04 3 90 100 110 120 =if(f3=f2,e2+d3,d3) 1/10/04 4 130 140 150 160 =if(f4=f3,e3+d4,d4) 1/10/04 What the formulas in column E say are to cumulate the totals for all dates that are the same. As soon as I change the date in column F, it starts over. These are weekly production "buckets." The problem arises when I want to move the data around. Let's say I want to move A22 and put it above what is now row 3 (by cutting and inserting cut cells). When I do that, the formulas in column E also change, throwing everything off. I have tried with and without dollar signs, I've tried using the R1C1 method, but no matter what I do, Excel tries to make the formulas match where I've moved the data. I thought "absolute" meant that it always refers to the same cell whether you move it or not but apparently I'm missing something. I want the formulas in column E to always remain frozen to whatever is in the referenced cells. Can I do this? Thanks for any help! Bill __________________ Bill in ABQ |
Thread Tools | |
Display Modes | |
|
|