用excel中DCOUNT求表中大于30小于50的年龄人数

2025-03-18 11:24:26
推荐回答(3个)
回答1:

database选整个表 如B1:E16

field年龄 如C1

criteria条件 从左到右选上如H17:I18

条件要这么输入   ="年龄"   输入""时要用英文输入法

                             >30

回答2:

=countifs(c:c,">30",c:c,"<50")

回答3:

=COUNTIFS(C2:C16,">30",C2:C16,"<50")
编审人数=COUNTIF(B2:B16,"编审")
有成绩=counta(e2:e16)