先在b列中找出在职人员，然后统计在职人员中统计h列中共党员的个数 ...

西瓜霜

先在b列中找出在职人员，然后统计在职人员中统计h列中共党员的个数
工作簿1.rar (18.66 KB, 下载次数: 11)

2021-11-10 17:19 上传

点击文件名下载附件
工作簿1.rar

高建波师悦未来校园

=COUNTIFS(B:B,"*在职",H:H,"中共党员")

=COUNTIFS(B:B,"*在职",J:J,">=30",J:J,"<=35")

何惧之有

=COUNTIFS(B:B,"*在职*",H:H,"中共党员")
=COUNTIFS(B:B,"*在职*",J:J,">=30",J:J,"<=35")

枯荷听雨

在职且是党员的人数
=COUNTIFS(B:B,"*在职*",H:H,"中共党员")
在职且是30-35年龄之间的人数
=COUNTIFS(B:B,"*在职*",J:J,">=30",J:J,"<=35")

龙邢天下

=COUNTIFS(B:B,"*"&"-在职",H:H,"中共党员")
=COUNTIFS(B:B,"*"&"-在职",J:J,">=30",J:J,"<=35")

昆山市东方驾校

=COUNTIFS(B:B,"*在职*",H:H,"*党员*")
=COUNTIFS(B:B,"*在职*",J:J,">29",J:J,"<36")

顺其自然顺意

1 =SUMPRODUCT((ISNUMBER(FIND("在职",$B$3:$B$60)))*($H$3:$H$60="中共党员"))
2 =SUMPRODUCT((ISNUMBER(FIND("在职",$B$3:$B$60)))*($J$3:$J$60>=30)*($J$3:$J$60<=35))

谭班长

1、=COUNTIFS($B$3:$B$60,"*"&"在职",$H$3:$H$60,"中共党员")
2、=COUNTIFS($B$3:$B$60,"*"&"在职",$J$3:$J$60,">=30",$J$3:$J$60,"<=35")