multiplying two columns

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.

The formula used is exactly as provided by airman, (cut and pasted).
No text anywhere at this stage.
I told you I was a Dummy!

You should probably try the simpler formulas suggested by oldchippy or myself. MMULT is best used for multiplying one array of cells by another, rather than a single cell by another. If this still doesn't work, please post your workbook.