I have two methods to do this, but not quite working out for me yes. The UDF is great but I don't want to save this workbook with macros. The Evaluate method seems to have to be in the same row.

Is there a formula solution?

2, 3, 6, 8 = 19

Ribbon > Formulas > Defined Names > Define Name

Name: MyArray

Refers to: =EVALUATE("{"&SUBSTITUTE($B8," ","")&"}")

Click OK

Then enter the following formula in C8...

=SUM(MyArray)

Is there a formula solution?

2, 3, 6, 8 = 19

Code:

```
Function Test(Rng As Range) As Variant
Test =Evaluate(Application.Substitute(Rng, ",", "+"))
End Function
```

Name: MyArray

Refers to: =EVALUATE("{"&SUBSTITUTE($B8," ","")&"}")

Click OK

Then enter the following formula in C8...

=SUM(MyArray)

Last edited: