I can easily sum a comma-separated list of values with a formula like:
I want to do the same thing with the list in a separate cell, so if A1 contains:
I would like a single cell formula to return 64
I can get an answer by using either TextToColumns or the UDF():
Option Explicit Public Function zum(SIN As String) As Variant Dim ary, a ary = Split(SIN, ",") For Each a In ary zum = zum + Val(a) Next a End Function
But I would rather use a single cell formula than VBA.