Excel Magic Trick 1538: Sum Last Digit of Each Cell in Range with SUM or SUMPRODUCT?

Download Excel Start Files: http://bit.ly/2FBEKxU
Entire page with all Excel Files for All Videos: http://bit.ly/1kSFWvs

In this video learn how to add the last digits from each cell in a range with the RIGHT and SUM or SUMPRODUCT function. Lean how to convert Text Numbers to Numbers by using any math operation.

View on YouTube