MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Adding numerical values from a alpha/numeric cell.


Posted by GARRET PETERSEN on January 14, 2002 6:52 AM

Example: C3 contains "2ADLOT" D4 contains "3ADLOT" I want to be able to add the "2" & "3". Is this possible without seperating the numeric and alpha values into different cells?
I have tried =SUMIF(C3:D4,"*ADLOT"). The result I'm looking for is 5.


Posted by Grumio on January 14, 2002 7:05 AM


If there is always only a single digit at the start of each string, then :-

=LEFT(C3,1)+LEFT(D4,1)


Posted by Mark W. on January 14, 2002 7:06 AM

=LEFT(C3)+LEFT(D4) (nt)