How Do I add/sum the numbers in one cell...((More Info Below))

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello. What I'm doing exactly is Let's Say A1 I have this:
1,5,8,9,10,12

And Now in A2 I want to put the sum of these numbers...

So I want to add the numbers even though they consist of commas.

Is this possible!? Hope you all can help me.
Thank you for your replies...
 
This is not the ideal solution and is undoubtably very inefficient but for
the one example you listed it works. One of the more savvy formula gurus
will probalby come up with something far better but this might at least give
you a place to start.

=LEFT(A1,1)+MID(A1,3,1)+MID(A1,5,1)+MID(A1,7,1)+MID(A1,9,2)+RIGHT(A1,2)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to add numbers in same cell? 2
Sum number range ignoring numbers formatted as text 0
Summing a variable range 6
How do I put a variable column number in the sum() function? 7
Conditional Sum of cells 1
question about SUM - how to sum each for elements 5
XL2002 SUM with a twist... 4
a1 = sum(a1;a2) 2

Back
Top