Count the commas.

=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))

pandd15 wrote:
My appologies for not doing a good job of explaining; these numbers are
product #'s, and vary in format, some with dashes some without, they also
vary in the amount of numerals and some have letters. I am interested only
in the total of numbers, as in 4 for the example below. They will always
have a coma and space between the numbers.

Thanks for your quick response.


700-2, 88-00,
900-4, 33-00,
Is there a formula that will add these numbers?
87563, 8930, 98279
The "numbers" you just posted don't look anything like the the numbers you
posted in your original sample!

What are the dashes for?

If these are the numbers:

700-2, 88-00,
900-4, 33-00,
Then what results do you expect?

What about that last comma? If there is not another number why is it there?

--
Biff
Microsoft Excel MVP


"pandd15" wrote in message
...
I tried this one =EVALUATE(SUBSTITUTE(A1,",","+")) , I must be doing
something wrong. I am new to Excel so I must be missing something. In
this
example what would the formula look like? The amount of numbers in C will
vary in each row.

a b c
d
1 700-2, 88-00,
900-4, 33-00,

2


3

Thanks so much.



"T. Valko" wrote:

One way...

The formula *must* be entered in the cell to the immediate right of the
cell
that you want to sum. For example:

E1 = 87563, 8930, 98279

The formula *must* be entered in cell F1.

Create this named formula.
Select cell B1. ***this is important***
Goto the menu InsertNameDefine
Name: ESum (or whatever name you want to use)
Refers to:

=EVALUATE(SUBSTITUTE(A1,",","+"))

OK out

Then:

E1 = 87563, 8930, 98279

Enter this formula in **F1** :

=ESum

--
Biff
Microsoft Excel MVP


"pandd15" wrote in message
...
My spreadsheet contains multiple numbers in one cell they are all
seperated
by a coma. Is there a formula that will add these numbers?

87563, 8930, 98279 are in one cell I'd like to have the total in
another
colum, the total of numbers not the sum, e.g. 3

Thanks,