Extracting Numbers from text

Or

Copy and paste the below formula In D2 cell - Array Formula Requires Ctrl+Shift+Enter instead of Normal Enter

For 2003 version

Formula:

=SUM(IF(ISERR(--MID(A3,ROW(INDIRECT("1:"&LEN(A3))),1)),0,--MID(A3,ROW(INDIRECT("1:"&LEN(A3))),1)))

Drag it down...

For 2007 or higher version - Array Formula Requires Ctrl+Shift+Enter instead of Normal Enter

Formula:

=SUM(IFERROR(--MID(A3,ROW(INDIRECT("1:"&LEN(A3))),1),0))