【函初201203班】-B35-平常心2011- 作业一
- =SUM(COUNTIFS(B12:B21,A25,E12:E21,">=60"),COUNTIFS(B12:B21,A25,F12:F21,">=60"),COUNTIFS(B12:B21,A25,G12:G21,">=60"))
- 作业二
- =SUM(COUNTIFS(A12:A21,"1",E12:E21,">=60",F12:F21,">=60",G12:G21,">=60"))
- =SUMPRODUCT((A12:A21=1)*(E12:E21>=60)*(F12:F21>=60)*(G12:G21>=60))
- 作业三
- =SUMPRODUCT((H$12:H$21>H12)*1)+1
- 作业四
- =SUMPRODUCT(($A$12:$A$21=A12)*($H$12:$H$21>H12))+1
- 作业五
- =ROUND(AVERAGEIFS(D12:D21,A12:A21,"1",C12:C21,"男"),)
- =ROUND(SUMPRODUCT(D12:D21*(A12:A21=1)*(C12:C21="男"))/COUNTIFS(A12:A21,"1",C12:C21,"男"),)
复制代码 |