How to count umbers in row without letters

LaurisK

Hello, I need to count numbers in rows but there is added letters, is it possible to count all numbers without letters?

I need information as displayed in image.

SteyJ

https://community.smartsheet.com/discussion/121237/how-to-count-umbers-in-row-without-letters

Hi @LaurisK,
Will each column have the same amount of characters before the number?
Is the number ever greater than or equal to 10?

If no to each of these, you can use something like this:
=SUM(VALUE(RIGHT([Primary Column]@row, 1)), VALUE(RIGHT([Column2]@row, 1)), VALUE(RIGHT([Column3]@row, 1)))