I have a group of numbers in a single cell, i.e.: 14 6 8 14 6 8. I
would like a formula that provides the sum of those numbers. I thought
I had seen a way to do that a few years ago, but my searches are
coming up empty. Should I be using text functions to isolate numbers,
or would I be better off trying to turn it into an array? It doesn't
seem that it should be that hard, but it's confounding me — maybe it's
lack of sleep...

Andy

Here's one way... Assuming that A2 contains the data, try the
following...

Insert Name Define

Name: Array

Refers to:

=EVALUATE("{"&SUBSTITUTE($A$2," ",",")&"}")

Click Ok

Then try...

=SUM(Array)

Hope this helps!

http://www.xl-central.com

In article
,
Green Fox wrote:

I have a group of numbers in a single cell, i.e.: 14 6 8 14 6 8. I
would like a formula that provides the sum of those numbers. I thought
I had seen a way to do that a few years ago, but my searches are
coming up empty. Should I be using text functions to isolate numbers,
or would I be better off trying to turn it into an array? It doesn't
seem that it should be that hard, but it's confounding me ‹ maybe it's
lack of sleep...

Andy

On Apr 1, 9:12Â*am, Domenic wrote:
Here's one way... Â*Assuming that A2 contains the data, try the
following...

Insert Name Define

Name: Â*Array

Refers to:

=EVALUATE("{"&SUBSTITUTE($A$2," ",",")&"}")

Click Ok

Then try...

=SUM(Array)

Hope this helps!

http://www.xl-central.com

In article
,
Â*Green Fox wrote:



I have a group of numbers in a single cell, i.e.: 14 6 8 14 6 8. Â*I
would like a formula that provides the sum of those numbers. I thought
I had seen a way to do that a few years ago, but my searches are
coming up empty. Should I be using text functions to isolate numbers,
or would I be better off trying to turn it into an array? It doesn't
seem that it should be that hard, but it's confounding me €¹ maybe it's
lack of sleep...

Andy- Hide quoted text -

- Show quoted text -

Thanks Domenic,
That was exactly what I wanted €” and so simple!

Andy