database选整个表 如B1:E16
field年龄 如C1
criteria条件 从左到右选上如H17:I18
条件要这么输入 ="年龄" 输入""时要用英文输入法
>30
=countifs(c:c,">30",c:c,"<50")
=COUNTIFS(C2:C16,">30",C2:C16,"<50")编审人数=COUNTIF(B2:B16,"编审")有成绩=counta(e2:e16)