Sum formula that ignores characters in a cell that aren't numbers

MikeWells13  i believe both SergeiBaklan  and davidleal  approaches basically strip out all text and give you a number from concatenating what is left.  I think you want/need it to treat each embedded number separately which my attachment above does.  here are the Lambda functions from that:

SumNumsFromTxt = LAMBDA(in,
    SUM(BYROW(in, LAMBDA(i, SUM(--CleanNumbers(Txt2Array(ExtractNumbers(i), ";"))))))
);

ExtractNumbers = LAMBDA(in,
    IF(
        ISBLANK(in),
        "",
        LET(
            _s, REDUCE(
                ";",
                MID(in, SEQUENCE(LEN(in)), 1),
                LAMBDA(prior, this,
                    prior &
                        IFS(
                            ISNUMBER(SEARCH(this, "0123456789,.")),
                            this,
                            RIGHT(prior, 1) = ";",
                            "",
                            TRUE,
                            ";"
                        )
                )
            ),
            _m, MID(_s, 2, LEN(_s)),
            IF(RIGHT(_m, 1) = ";", LEFT(_m, LEN(_m) - 1), _m)
        )
    )
);
CleanNumbers = LAMBDA(in,
    BYROW(
        in,
        LAMBDA(i,
            IFERROR(
                --i,
                IFERROR(--SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(i, ",", "?"), ".", ","), "?", "."), 0)
            )
        )
    )
);

Txt2Array = LAMBDA(string, delim,
    LET(
        _L, LEN(string),
        _d, IF(ISOMITTED(delim), ",", delim),
        _count, _L - LEN(SUBSTITUTE(string, _d, "")),
        IF(
            _count,
            TRIM(MID(SUBSTITUTE(string, _d, REPT(" ", _L)), SEQUENCE(_count + 1, 1, 1, _L), _L)),
            string
        )
    )
);

but as you can see it has quite a bit and especially with newer functions introduced since then could be optimized, but then again, if it works...