software

I have two cells with values in each, i want to total the values of the
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 the
help...--
afntex
------------------------------------------------------------------------
afntex's Profile: www.excelforum.com/member.php...oamp;userid=32408
View this thread: www.excelforum.com/showthread...hreadid=521744
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--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=521744Say 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
--
Gary's Studentquot;afntexquot; wrote:

gt;
gt; I have two cells with values in each, i want to total the values of the
gt; two cells, but the first character in the cell is an alpha character.
gt; Is there a way of getting the sum of the two cells? Thanks for the
gt; help...
gt;
gt;
gt; --
gt; afntex
gt; ------------------------------------------------------------------------
gt; afntex's Profile: www.excelforum.com/member.php...oamp;userid=32408
gt; View this thread: www.excelforum.com/showthread...hreadid=521744
gt;
gt;