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

一村之长

注意：
1、本次作业按代码方式提交公式即可，注明学号以及ID；
2、不接受附件上传， 回帖方式不正确不评分或者扣分；
3、回复不要重复占楼，修改请在原楼层，不要回复学委点评，本帖已设置回复仅作者可见；
4、非本组学员勿跟帖，违者扣分删帖处理；
5、作业截止时间：下周一（7月13日）18:00
作业机票：http://www.excelpx.com/thread-366827-1-1.html
格式机票：http://www.excelpx.com/thread-365873-1-1.html

CocoXie

B10：Coco Xie
第一题

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

复制代码

第二题

1. =COUNTA(B13:D18)-COUNT(B13:D18)

复制代码

第三题

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")

复制代码

回答完毕

study_harder

B02：study_harder
1.

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

复制代码

2.

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

复制代码

3.

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

复制代码

4.

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

复制代码

回答完毕。

fang322521

B06：fang322521
1、

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

复制代码

2、

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

复制代码

3、

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

复制代码

4、

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

复制代码

5、

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

复制代码

青舟

B04：青舟
第一题

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

复制代码

1. =COUNT(0/(B5:D10>60))

复制代码

1. =SUMPRODUCT((B5:D10>60)*1)

复制代码

1. =SUM((B5:D10>60)*1)

复制代码

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

复制代码

1. =SUM(N(B5:D10>60))

复制代码

1. =SUM(SIGN(B5:D10>60))

复制代码

第二题

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

复制代码

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

复制代码

1. =SUMPRODUCT((B13:D18=TRUE)*1)

复制代码

1. =SUM((B13:D18=TRUE)*1)

复制代码

1. =COUNT(0/(B13:D18=TRUE))

复制代码

第三题

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

复制代码

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

复制代码

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

复制代码

1. =COUNT(0/((C22:C36="A类")*(D22:D36="一年级")*(E22:E36="女")*(F22:F36>60)))

复制代码

第四题

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

复制代码

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

复制代码

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

复制代码

1. =COUNT(0/((C40:C54="A类")*(D40:D54="一年级")*(F40:F54<=60)))

复制代码

第五题

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

复制代码

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

复制代码

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

复制代码

1. =COUNT(0/((C58:C72="A类")*(E58:E72>60)*(F58:F72>60)))

复制代码

答题完毕。

coolppt

B18：coolppt
第一题

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

复制代码

第二题

1. =COUNTIF(B13:D18,TRUE)

复制代码

第三题

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")

复制代码

Miss_MT

B14:Miss_MT
第一题

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

复制代码

第二题

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

复制代码

第三题

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")

复制代码

——————————————这次的题少多啦！回答完毕~——————————————————————

jzkwf

B03：jzkwf
第一题：

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")

复制代码

回答完毕

dzj4717642

B05：dzj4717642
第一题

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")

复制代码

回答完毕。

阳光暖

B16：阳光暖
第一题：

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

复制代码

第二题：

1. =COUNTIF($$$$B$$$$13:$$$$D$$$$18,C15)

复制代码

第三题：

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")

复制代码

回答完毕