"&{70,80})*{1,-1}), =SUM(COUNTIF(date!H:H,">"&{70,80})*{1,-1}),统计date工作表H列中,大于70小于等于80的记录个数:函数公式中用到了二个常量数组. 等同于:COUNTIF(date!H:H,">70")-COUNTIF(date!H:H,">80")crazy0031月殇战团iH">

=SUM(COUNTIF(date!H:H,">"&{70,80})*{1,-1}),

问题描述：

=SUM(COUNTIF(date!H:H,">"&{70,80})*{1,-1}),
1个回答 分类：综合 2014-11-30

问题解答：

我来补答
统计date工作表H列中,大于70小于等于80的记录个数；
函数公式中用到了二个常量数组.
等同于：
COUNTIF(date!H:H,">70")-COUNTIF(date!H:H,">80")
 
 
展开全文阅读
剩余:2000字
上一页：hfftbjhg
下一页：证明下列各式，怎么做
也许感兴趣的知识