Summing Numbers in Cells Including Consecutive Numbers

[NeilsonWheels]

Hi All,

I want to take a cell (A1) with a value such as "M12G3" and sum the values of these numbers. The answer to this problem would be 15 (12+3) and not 6 (1+2+3)

I got as far as [=SUM(IFERROR(VALUE(MID(A1,SEQUENCE(LEN(A1)),1)),0))]. This gives the incorrect answer and cant handle consecutive numbers :(.

This solution can't use vba/macros. I'm not sure where to go from here