|
D11:酒醒梦已残
1.- =COUNTIF(B5:D10,">60")
- =COUNTIFS(B5:D10,">60")
- =SUM(IF(B5:D10>60,1,"")),数组公式
复制代码 2.- =COUNTA(B13:D18)-COUNT(B13:D18)
- =COUNTIF(B13:D18,TRUE)
- =SUM(IF(B13:D18>100,1,"")),数组公式
- =COUNT(IF(B13:D18>100,1,"")),数组公式
复制代码 3.- =COUNTIFS(C22:C36,"A类",D22:D36,D22,E22:E36,E24,F22:F36,">60")
- =SUMPRODUCT((C22:C36&D22:D36&E22:E36="A类一年级女")*(F22:F36>60))
- =SUM((C22:C36&D22:D36&E22:E36="A类一年级女")*(F22:F36>60)),数组公式
- =SUM((C22:C36="A类")*(D22:D36="一年级")*(E22:E36="女")*(F22:F36>60))
- ,数组公式
复制代码 4.- =COUNTIFS(C40:C54,C40,D40:D54,D40,F40:F54,"<=60")
- =SUMPRODUCT((C40:C54&D40:D54="A类一年级")*(F40:F54<60))
- =SUM(((C40:C54&D40:D54)=C40&D40)*(F40:F54<60)),数组公式
- =SUM((C40:C54&D40:D54="A类一年级")*(F40:F54<60)),数组公式
复制代码 5.- =COUNTIFS(C58:C72,C58,E58:E72,">60",F58:F72,">60")
- =SUMPRODUCT((E58:E72>60)*(F58:F72>60)*(C58:C72="A类"))
- =SUM((E58:E72>60)*(F58:F72>60)*(C58:C72="A类")),数组公式
复制代码 |
评分
-
查看全部评分
|