=0"),COUNTIF(K3:T3,"" /> =0"),COUNTIF(K3:T3," - 作业答案大全" />

COUNTA(K3:T3)-SUM(COUNTIF(K3:T3,">=0"),COUNTIF(K3:T3,"

问题描述:

COUNTA(K3:T3)-SUM(COUNTIF(K3:T3,">=0"),COUNTIF(K3:T3,"

K3:T3的单元格中有数据的单元格的个数减去数字单元格的个数.
公式可以用
=counta(k3:t3)-count(k3:t3)
代替我是想在有文字和数字的单元格中提取数字,相加,可是这个公式没用啊,有其他的公式吗?既能好理解,又实用?那就直接用 =sum(k3:t3) 就可以了呀