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?