Problem: 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

mattless1

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.