excel中同时满足一列中满足多个条件中任意一种条件,另一列中满足一种...

发布网友发布时间：2024-03-26 08:45

共5个回答

热心网友时间：2024-08-16 13:17

求张三白班天数
=SUMPRODUCT((B2:B8="张三")*(C2:C8="白班"))
求张三中班天数
=SUMPRODUCT((B2:B8="张三")*(C2:C8="中班"))
求张三白班与中班的总天数
=SUMPRODUCT((B2:B8="张三")*((C2:C8="白班")+(C2:C8="中班")))

热心网友时间：2024-08-16 13:18

在D2中写
=COUNTIFS($C$2:$C$8,"中班",B2:B8,"张三")+COUNTIFS($C$2:$C$8,"白班",B2:B8,"张三")

热心网友时间：2024-08-16 13:12

=SUMPRODUCT((B2:B8="张三")*(C2:C8="白班"))+SUMPRODUCT((B2:B8="张三")*(C2:C8="中班"))
or
=SUMPRODUCT((B2:B8="张三")*((C2:C8="白班")+(C2:C8="中班")))

热心网友时间：2024-08-16 13:20

=COUNTIFS(B:B,"张三",C:C,"白班")
你试试这个公式是你要的嘛

热心网友时间：2024-08-16 13:13

2007以上版本输入以下公式
=COUNTIFS(B:B,"张三",C:C,"白班")
=COUNTIFS(B:B,"张三",C:C,"中班")