|
E04:slg36
1、方法一:方法二:数组公式方法三:数组公式方法四:- =SUMPRODUCT((B5:D10>60)*1)
复制代码 2、数组公式- =SUM(COUNTIF(B13:D18,{"true",1}))
复制代码 3、方法一:- =COUNTIFS(C22:C36,"A类",D22:D36,"一年级",E22:E36,"女",F22:F36,">60")
复制代码 方法二:- =SUMPRODUCT((C22:C36="A类")*(D22:D36="一年级")*(E22:E36="女")*(F22:F36>60))
复制代码 方法三:数组公式- =SUM((C22:C36="A类")*(D22:D36="一年级")*(E22:E36="女")*(F22:F36>60)*1)
复制代码 4、方法一:- =COUNTIFS(C40:C54,"A类",D40:D54,"一年级",F40:F54,"<=60")
复制代码 方法二:- =SUMPRODUCT((C40:C54="A类")*(D40:D54="一年级")*(F40:F54<=60))
复制代码 方法三:数组公式- =SUM((C40:C54="A类")*(D40:D54="一年级")*(F40:F54<=60)*1)
复制代码 5、方法一:- =COUNTIFS(C58:C72,"A类",E58:E72,">60",F58:F72,">60")
复制代码 方法二:- =SUMPRODUCT((C58:C72="A类")*(E58:E72>60)*(F58:F72>60))
复制代码 方法三:数组公式- =SUM((C58:C72="A类")*(E58:E72>60)*(F58:F72>60)*1)
复制代码 |
评分
-
查看全部评分
|