Hi All,
Can anyone help me in writting a formula to find the sum of comma
separated numbers in a cell
Thanks in advance
Xcelion


--
xcelion
------------------------------------------------------------------------
xcelion's Profile: http://www.excelforum.com/member.php...o&userid=16287
View this thread: http://www.excelforum.com/showthread...hreadid=397168

Xcelion,

There isn't a native Excel function that can do this, but you can write one easily enough. Drop this function into VB:

---------------------
Function Sum_CSV(CSV_String)

CSV_Temp = "=SUM(" & CSV_String & ")"

Sum_CSV = Evaluate(CSV_Temp)

End Function
---------------------

then use the function as you would any other:

=Sum_CSV(A1)

Knightly

Thanks sirknightly for you answer

This looks fine But i would like to know whether this can be expresses
as formula


--
xcelion
------------------------------------------------------------------------
xcelion's Profile: http://www.excelforum.com/member.php...o&userid=16287
View this thread: http://www.excelforum.com/showthread...hreadid=397168

Good morning xcelion

As sirknightly says it can't be done by Excel without resorting to
writing your own function - and the one he supplied works just fine.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=397168