How to add numbers in a cell that are separated by commas

[zkiraly]

Hi,

I'm wondering:

If I have the following list of numbers contained in a cell:

1, 5, 3, 11,

How can I get excel to add these numbers and put the answer in
cell C9.

Thanks

 

[just_jon]

Re: How to add numbers in a cell that are separated by comma

Hi, hello and welcome to MrExcel - one way -

TESTX.xls
	G	H	I	J
7	1,5,3,11,
8	20
Hrs

The EVAL function is part of the morefunc add-in. The Morefunc add-in is a free download, available at: this site.

 

[Aladin Akyurek]

Re: How to add numbers in a cell that are separated by comma

If no extraneous commas at the beginning or the end of the string...

=SUM(EVAL("{"&A1&"}"))

would suffice.