西瓜霜 发表于 2021-11-10 17:19:00

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

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

高建波师悦未来校园 发表于 2021-11-18 12:08:51

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

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

何惧之有 发表于 2021-11-21 13:51:27

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

枯荷听雨 发表于 2021-12-26 20:38:06

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

龙邢天下 发表于 2021-12-30 09:42:44

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

昆山市东方驾校 发表于 2022-1-23 02:17:40

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

顺其自然顺意 发表于 2022-1-24 07:07:51

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))

谭班长 发表于 2022-1-26 10:23:54

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")
页: [1]
查看完整版本: 先在b列中找出在职人员，然后统计在职人员中统计h列中共党员的个数 ...