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

Matt, you've already got infractions on you for not following the forum rules. Try to fix your thread title before your get infracted again.

The rules make the forum EASY for people to research data for themselves. "Problems Problems Problems" makes your thread pointless for others. Fix your title, dude.

And the duplicate posts...ouch.
http://www.excelforum.com/excel-gene...on-issues.html

Meanwhile, your issue is an easy one, so we can help pretty fast once you fix that title.

Read the Forum Rules.

Sorry new to all this. not sure how i'm mean't to word things.

Tryied the example you gave me it works fine, but if i take one away it does not reduce the number.

Big thanks you for helping me

The solution I suggest is:

=IF(LEN(A2),LEFT(A2,1)*1,0)+IF(LEN(B2),LEFT(B2,1)*1,0)+IF(LEN(C2),LEFT(C2,1)*1,0)+IF(LEN(D2),LEFT(D2,1)*1,0)

Not very elegant, but at least it works.

========
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


======
(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)