怎样实现用countif函数实现.计数大于80,小于等于90
发布网友
共1个回答
热心网友
如用 Countif:
=countif(A1:A100,"<=90")-countif(A1:A100,"<=80")
如用Sumproct:
=sumproct((A1:A100>80)*(A1:A100<=90))
