Need help in summing up number within a cell

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:48 PM GMT


Here's the scenario

I have this set of numbers 3864-8 in A1 ,3496-333 in A2 and this goes to let say up to A2000, What i want to have is to sum up the last digit of this set of numbers (i.e. 8,333, etc)?



This array formula will do it


ensure that the range is the same as the range you are actually using, and that all cells have a - sign in them or it will fall over - enter the formula above and use ctrl shift enter to accept it - this will then return the result you want.


©2024 eLuminary LLC. All rights reserved.