Help please

A

afntex

I have two cells with values in each, i want to total the values of th
two cells, but the first character in the cell is an alpha character
Is there a way of getting the sum of the two cells? Thanks for th
help..
 
R

Ron Coderre

Not quite sure what you want, but here's a guess

A1: A010
B1: L001
C1: =SUMPRODUCT(--MID(A1:B1,2,255))

In that instance, the formula returns 11

Does that help?

Regards,
Ron
 
G

Gary''s Student

Say you have Z100 in A1 and Q35 in A2 then in A3 enter:

=RIGHT(A1,LEN(A1)-1)+RIGHT(A2,LEN(A2)-1) to display 135
 
Top