单元格里的数字都是用逗号隔开,请问怎么计算他们的和?

=SUMPRODUCT(--(0&TRIM(MID(SUBSTITUTE(A1,",",REPT(" ",99)),(ROW($1:$100)-1)*99+1,99))))