【函中20130301】第八讲B组作业上交帖【开贴】

wangjianff

第一题：条件{"工资","工资","性别";">400","<=500","女"}

1. =DCOUNT(A2:C11,"工资",A13:C14)

复制代码

第二题：条件=AND((B3="女"),(C3>400),(C3<=500))

1. =DCOUNT(A2:C11,3,A17:A18)

复制代码

第三题：条件{性别,;男,=C3<AVERAGE($C$3:$C$11)}

1. =DCOUNT(A2:C11,3,A20:B21)

复制代码

第三题：条件{性别,;男,=C3<AVERAGEIF(B3:B11,"男",C3:C11)}

1. =DCOUNT(A2:C11,3,A23:B24)

复制代码

第四题:条件{"性别","性别";"男","女"}

1. =DAVERAGE(A2:C111,3,A26:A27)-DAVERAGE(A2:C111,3,B26:B27)

复制代码

第五题：条件{"产品",;"白炽灯",=B31=C31}

1. =DCOUNT(A30:C45,3,D30:E31)

复制代码

【函中201301班】- B12-wangjianff
最近比较忙 来晚了 已经开贴了都 补交作业 老师学委辛苦了