Formula to sum comma-delimited values in a cell which can work for Excel for the web

[XL123]

Hi,
I have been trying to get a formula that would work in the online version of Excel which will allow me to sum comma-delimited values in a cell. For e.g per below
in cell A2 I have: 2,3,4,15 and in B2 the formula should give a total of 24. The formula should be able to copied down column B
Hope image below clarifies the question.

Team 1	Total
2,3,4,15	24​
5,10,15,22	52​
1,3,29	33​

 

[Fluff]

How about

=SUM(--(TRIM(MID(SUBSTITUTE(A2,",",REPT(" ",100)),SEQUENCE(LEN(A2)-LEN(SUBSTITUTE(A2,",",""))+1,,,100),100))))

 

[XL123]

Your formula simply works. Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.