Calculation issues

Could somone please help me? im trying to make a order form for my work and on my order form i have numbers and text in the same cell but i have more than one cell. i have calculated them up with the =LEFT(A1,1)*1 but as there are more cells when i remove any of them items it gives me #VALUE!. Is there any way i can do this?

I have atteched a sample

it would be greatly appricated