2015年【函初1班】第三讲作业B组提交贴

大猫喵喵

B17：大猫喵喵
第一题：

1. =COUNTIF(B5:D10,">60")

复制代码

第二题：

1. =COUNTIF(B13:D18,TRUE)

复制代码

第三题：

1. =COUNTIFS(C22:C36,C22,D22:D36,D22,E22:E36,E24,F22:F36,">60")

复制代码

第四题：

1. =COUNTIFS(C40:C54,C40,D40:D54,D40,F40:F54,"<=60")

复制代码

第五题：

1. =COUNTIFS(C58:C72,C58,E58:E72,">60",F58:F72,">60")

复制代码

广陵王

B01:广陵王
第一题

1. =COUNTIFS(B5:D10,">60")

复制代码

第二题

1. =COUNTIFS(B13:D18,"TRUE")

复制代码

第三题

1. =COUNTIFS(C22:C36,"A类",D22:D36,"一年级",F22:F36,">60",E22:E36,"女")

复制代码

第四题

1. =COUNTIFS(C40:C54,"A类",D40:D54,"一年级",F40:F54,"<60")

复制代码

第五题

1. =COUNTIFS(C58:C72,C58,E58:E72,">=60",F58:F72,">=60")

复制代码

回答完毕

橙桔仔

B22：橙桔仔
第一题

1. =COUNTIF(B5:D10,">60")

复制代码

第二题

1. =COUNTIF(B13:D18,TRUE)+COUNTIF(B13:D18,"TRUE")

复制代码

第三题

1. =COUNTIFS(C21:C36,"A类",D21:D36,"一年级",E21:E36,"女",F21:F36,">60")

复制代码

第四题

1. =COUNTIFS(C39:C54,"A类",D39:D54,"一年级",F39:F54,"<60")

复制代码

第五题

1. =COUNTIFS(C39:C54,"A类",D39:D54,"一年级",F39:F54,"<60")

复制代码

王晓朱

{:1112:}

心的距离

B组长：心的距离
第一题

1. =COUNTIF(B1:D5,">60")

复制代码

第二题

1. =COUNTIF(B13:D18,1=1)

复制代码

第三题

1. =COUNTIFS(C22:C36,"A类",D22:D36,"一年级",E22:E36,"女",F22:F36,">60")

复制代码

第四题

1. =COUNTIFS(C40:C54,"A类",D40:D54,"一年级",F40:F54,"<=60")

复制代码

第五题

1. =COUNTIFS(C58:C72,"A类",E58:E72,">60",F58:F72,">60")

复制代码

wy小酒窝

B09：wy小酒窝
1

1. =COUNTIF(B5:D10,">60")

复制代码

2

1. =COUNT(B13:D18)

复制代码

1. =COUNTIF(B13:D18,">0")

复制代码

3

1. =COUNTIFS(C21:C36,"A类",D21:D36,"一年级",E21:E36,"女",F21:F36,">60")
   

复制代码

4

1. =COUNTIFS(C39:C54,"A类",D39:D54,"一年级",F39:F54,"<=60")

复制代码

5

1. =COUNTIFS(C57:C72,"A类",E57:E72,">60",F57:F72,">60")

复制代码

王者归来520

b07:王者归来520
第一题：

1. =COUNTIF(B5:D10,">60")

复制代码

第二题：

1. =COUNTIF(B13:D18,B13)

复制代码

第三题

1. =COUNTIFS(C22:C36,C22,D22:D36,D22,E22:E36,E36,F22:F36,">60")

复制代码

第四题：

1. =COUNTIFS(C40:C54,C40,D40:D54,D40,F40:F54,"<60")

复制代码

第五题：

1. =COUNTIFS(C58:C72,C58,E58:E72,">60",F58:F72,">60")

复制代码

回答完毕

zuokanyunqi7203

第一题：

1. =COUNTIF(B5:D10,">60")

复制代码

第二题：

1. =COUNTIF(B13:D18,"TRUE")

复制代码

第三题：

1. =COUNTIFS($C$22:$C$36,$C$22,$D$22:$D$36,$D$22,$E$22:$E$36,$E$24,$F$22:$F$36,">60")

复制代码

第四题：

1. =COUNTIFS($C$40:$C$54,$C$40,$D$40:$D$54,$D$40,$F$40:$F$54,"<=60")

复制代码

第五题：

1. =COUNTIFS(C58:C72,C58,E58:E72,">60",F58:F72,">60")

复制代码

绝对引用和相对引用在这题目中有区别吗？
最近一直没时间上线，下周估计就有时间了，要好好把这两讲的课程及作业恶补一下。

yifan7203

B20:yifan7203

第一题：

1. =COUNTIF(B5:D10,">60")

复制代码

第二题：

1. =COUNTIFS(B13:D18,"=TRUE")

复制代码