Need help in summing up number within a cell

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

Question

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)?


Jn

Answer

This array formula will do it

=SUM(VALUE(RIGHT(A1:A2000,LEN(A1:A2000)-SEARCH("-",A1:A2000))))

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.

Advertisement

©2021 eLuminary LLC. All rights reserved.