Computer Hope
Software => Computer software => Topic started by: Shadow_unk on April 17, 2005, 01:18:34 PM
-
I have a problem i don't know how to copy a cell's formula in the way i want. (Example *1*) :
_______________________________________ _____
|__|____A____|_B_|_______C_______|_____D_____|
| 1 | """""""""""" |""""|"""""""""""""""""""" | 200.000 |
| 2 | 10.000 |""""|=SUM(A2*D1) | """"""""""""""" |
| 3 | 12.335 |""""|=SUM(A3*D1) |=SUM(A3*D1)|
| 4 | 12.387 |""""|=SUM(A4*D1) | """"""""""""""" |
| 5 | 12.370 |""""|=SUM(A5*D1) | """"""""""""""" |
I have tried to drag the cell all the way down but i obtained (Example *2*):
_______________________________________ _____
|__|____A____|_B_|_______C_______|_____D_____|
| 1 | """""""""""" |""""|"""""""""""""""""""" | 200.000 |
| 2 | 10.000 |""""|=SUM(A2*D1) | """"""""""""""" |
| 3 | 12.335 |""""|=SUM(A3*D2) |=SUM(B3*E2)|
| 4 | 12.387 |""""|=SUM(A4*D3) | """"""""""""""" |
| 5 | 12.370 |""""|=SUM(A5*D4) | """"""""""""""" |
And i have tried the old fashion ctrl+c and ctrl+v and i obtained (Example *3*):
_______________________________________ _____
|__|____A____|_B_|_______C_______|_____D_____|
| 1 | """""""""""" |""""|"""""""""""""""""""" | 200.000 |
| 2 | 10.000 |""""|=SUM(A2*D1) | """"""""""""""" |
| 3 | 12.335 |""""|=SUM(A3*D2) |=SUM(B3*E2)|
| 4 | 12.387 |""""|=SUM(A4*D3) | """"""""""""""" |
| 5 | 12.370 |""""|=SUM(A5*D4) | """"""""""""""" |
Please help me because i have to do 300 lines in that type of way (Example *1*), and i don't want to change each line's formula. PLEASE HELP !
P.S
- """"" in the examples is equal to nothing
- Excuze me if it is a n00b question for u, but for me this is a problem that exceeds me.
-
Shadow,
Use a constant sign "$" e.g. =sum(A2*$D$1). This way as you copy the A2 will increment but teh $D$1 will remain constant, you then just copy that formular all the way down. ;D
-
Thank you very very much !!!!!!
-
Glad to have helped :)