作者:乔山办公网日期:
返回目录:excel表格制作
COUNTIF无法多条zd件计数,可用两个函数相减:
=COUNTIF(A:A,"<=90")-COUNTIF(A:A,"<80")
如果内是2007版或容2010版,可用COUNTIFS。
=COUNTIFS(A:A,">=80",A:A,"<=90")
03版也可用
=SUMPRODUCT((A1:A100>=80)*(A1:A100<=90))
假设数据区A1:A12 =COUNTIF(A1:A12,">=80")-COUNTIF(A1:A12,">90")
=SUMPRODUCT(((A1:A15)>80)*((A1:A15)<90)*(A1:A15)))
这个公式也可以达到相同的效果
21使用IF函数判断考核成绩是否合格
A1=85
B1=IF(A1<70,"罚1",IF(A1<=80,"无奖","奖1"))