How do I sum up the last two characters of a cell?


I have a column where the last two characters are a number. If I do


I get the correct number. I can also add Value(right(cell1,2) +Value(right(cell2,2)

But I would like to calculate a cell to be the sum of the right two characters in a column in another sheet. How do I do that?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!