Find the sum of Comma Seperated Values In a Cell

X

xcelion

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
 
S

sirknightly

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
 
X

xcelion

Thanks sirknightly for you answer

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

dominicb

Good morning xcelion

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

HTH

Dominic
 
Top