Question !!! (n00b) (EXCEL)

[Shadow_unk]

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.

[cigarman]

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.

[Shadow_unk]

Thank you very very much !!!!!!

[cigarman]

Glad to have helped