multiplying two columns

Be nice to me I am an Excel Dummy.
I would like somebody to advise me on the following.
Assume column B is 31 cells long with a value in each cell all the way down.
I wish to progressively add a value to column A (say on a daily basis) which is to be multiplied by the constant value in Column B and showing a total in Column C, at the same time showing a total at the bottom of A and C.
Any assistance would be appreciated, please forgive my ignorance.

Hey COLC, Just in the door myself...

Presume you'll start at A1, B1 & C1 and are using numbers only.
Go to C1 and type this: =IF(A1="","",(MMULT(A2,B2)))
What this means is: IF A1 is Blank then do nothing, otherwise multiply A1 x B1. Next click on C1 and hover over the small black square at the bottom right of the cell (the "Cursor" will change when you are on it), hold the mouse button and drag it all the way down to C31. (This repeats the formula for all the selected cells. (Don't write in these...you'll delete the formulas)

Now go Col A32 (Where you want to total A) and type: =SUM(
Select A31, hold the mouse and drag it up to A1 (You'll see a dotted box covering the selected cells that you want.) let go and hit Return/Enter.this adds A1, A2, A3....A31

Do the same for Col C

How'd I do?

The formula in column C could be shortened to =A1*B1. If nothing is in A1, it will just return 0.

A B C
1 0.5081644 1.0163288
2 0.5081644 2.540822
5 0.5081644 2.0326576
4 0.5081644 3.0489864
6 0.5081644 2.0326576
4 0.5081644 #VALUE!
Thanks Guys,
I seem to have struck a hurdle at the first!, I have only tried the first part of the formula A X B and as can be seen above the Column C total does not correspond correctly ie A1 X B1 should be 0.5081644 and so on.
Either I have not explained my problem adequately or made an error somewhere.
Any clues?

Just a hunch, but it looks like your formula is =A2*B1. If you have text in A7, this would also explain the error.