A formula based alternative may be this; (prepared on Excel 2010)
=SUMPRODUCT((TRIM(MID(SUBSTITUTE(A1& ",";",";REPT(" ";255));1+(ROW(A$1:A$999)-1)*255;255)) & "0")/10)