Formula for Mic. Excel '03

[Issmortor]

ok...im kinda new to Excel, but i figure all your computer wiz peeps out there will have no problem with this one:

ok, i have 5 columns ABCDE
and 20 rows

i need to have is do like ((C1*B1)+(C2*B2)+(C3+B3)...) will display in C20
and the same thing for ((D1*B1)+(D2*B2)...) and display in D20
and the same for column E

any help you can give me on hwo to make this work woud be much appreciated, thanks

edit:...wow, ok i didnt know that that what i typed up there would actually work when put in...ok i feel dumb now...

edit edit: but wait...is there a way i can do it so i dont have to type that for each and every column, or do i have to do that?

[PhyuckYu]

When you put your cursor in the corner of one of the cells, a crosshair should appear. Drag that down to the rest of the rows, and the formula will be copied there but it will change all the "D"s to "E"s and so on...

Edit: You should also change all the B# to $B$#. Like when you have B2, make it $B$2