How about this:

=SUM(--MID(SUBSTITUTE($A$1;",";0);ROW(A1:INDIRECT("A"&LEN(A1)));1))

Comfirmed with ctrl+shift+enter

(replace ; with , if needed)