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)