excel哪个公式是计算一个单元格里的数字数量的?（里面的数字我已经用逗号隔开了）

Question

如题所述

Answer 1

计算数字的个数该用这公式就行了：

=IF(A1="","",LEN(SUBSTITUTE(A1,",",)))

如果是计算逗号的数量，用这公式：

=IF(A1="","",LEN(A1)-LEN(SUBSTITUTE(A1,",",)))

Answer 2

=len(a1)-len(substitute(a1,",","'))+1