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.