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 :-


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

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