You are very close. Use =A1*B1
SUM is for summing (adding) as in =SUM(A1:A10) to add cells A1+A2+..A9+A10
And formulas begin with = not @ (that was Lotus)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"spudsnruf" wrote in message
...
I'm not sure If I'm going mad or not...but a really simple equation in a
spreadsheet is not working...

My table is, eg, as below

A B C
1 5% 10
2 3% 12

in column C, i just want to get the total of a1 * b1, eg total = 0.5,
I was just assuming i could do @sum(a1*b1)......but that doesnt work

Any help please?

Thank you