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. Thank you very very much !!!!!!Glad to have helped