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

mtarler 

As variant

sumFromTxtRange = LAMBDA(range,
    LET(
        getNumber, LAMBDA(str,
            LET(
                inNumers, CHAR(VSTACK(SEQUENCE(4, , 43), SEQUENCE(10, , 48))),
                chars, LAMBDA(str, MID(str, SEQUENCE(LEN(str)), 1)),
                addChar, LAMBDA(str, chr,
                    str & XLOOKUP(chr, inNumers, inNumers, "")
                ),
                --REDUCE("", chars(str), addChar)
            )
        ),
        SUM(MAP(range, getNumber))
    )
);