Google Sheets: Need to total numbers contained in the same cells as text.

[Matthew Sid]

I've been searching and trying different formulas for hours and got nowhere. I need to total the numbers in a row that contains both text and numbers excluding black cells
Example: B4 = "2 Dave", B5="4 Steve"
I want that to show a total of 6.

Tried SUMIF and SUMPRODUCT with ISNUMBER, but just getting errors.

Any help is appreciated. Thanks

 

[Peter_SSs]

Thank you! That worked

You're welcome.

And apologies for posting in the wrong thread forum.

We understand that you are new to the forum so no real problem - so long as you remember for the next time.