2015年【函初1班】第三讲作业D组提交贴（开）

jeans0408

D13:jeans0408
第一题:

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

复制代码

第二题:

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

复制代码

第三题:

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

复制代码

第四题:

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

复制代码

第五题:

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

复制代码

回答完毕

wqy717642

D12：wqy717642
第一题

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

复制代码

第二题

1. =COUNTIF(B13:D18,B13)

复制代码

第三题

1. =COUNTIFS(C22:C36,"A类",D22:D36,"一年级",E22: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")

复制代码

回答完毕。

妖妖在山林

D21:妖妖在山林
第一题：

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

复制代码

第二题：

1. =COUNTIF(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. =COUNTIFS(C40:C54,"A类",D40:D54,"一年级",F40:F54,"<60")

复制代码

1. =SUMPRODUCT((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))

复制代码

mikang258

D19：mikang258

第一题

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

复制代码

回答完毕。
公司电脑无法提交附件，先把作业交了，怕来不及。
谢谢学委。

双修的苏摩尔

D04: 双修的苏摩尔
第一题

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

复制代码

第二题

1. =COUNTIF(B13:D18,TRUE)

复制代码

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

复制代码

第三题

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

复制代码

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

复制代码

第四题

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

复制代码

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

复制代码

第五题

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

复制代码

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

复制代码