How to sum all the numbers where there is a letter together with the numbers in the cell?

Patrikas ✭✭
edited 06/16/22 in Formulas and Functions


I need some help adding all the hours in the range, but in each cell there will be a letter:

I need to get '20' without any letters. Is it possible to do? Thank you in advance!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!