Hello all

I have a spreat sheet that looks something like this:

Cases Total cigarettes
13*10*20 2,600
13*10 130
12*10*20 2,400

with col A as "Cases" & column b "total ciggies"

basically I want a formula to calculate the sum in col A to display the
result in col B

without having to manually into the calculation each time & without using
"Text to Columns" if possible

any help please?