How to add cells in Google Docs, provided that some may contain not only numbers, but also letters?

Question

Mathematics

How to add cells in Google Docs, provided that some may contain not only numbers, but also letters? There are cells with numbers, and there is a number and a word. How to add all numbers, all cells?

Answer 1

enter an additional column in which numbers from all lines will be converted and highlighted
=IFERROR(Value(REGEXEXTRACT(Text(A1;"$0.00");"[0-9]+"));0)
"$0.00" - number format.
Sum it up.
If there are lines in which there is only a word, there are no numbers - 0 will be returned