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