求教countifs函数，一个区域，多个条件“和”的关系，怎么写公式简便

Langzi_xiaoyi · 发表于 2016-2-29 11:39

如题，求大神支招

wangjguo44 · 发表于 2016-2-29 11:46

=SUM(COUNTIFS(C:C,"是",B:B,{"领班级","员工级（高级员工）","主管级"}))

复制代码

Langzi_xiaoyi · 发表于 2016-2-29 11:54

wangjguo44 发表于 2016-2-29 11:46

跪谢大神，已经解决，我是新手，没有鲜花，我先解决下问题，改天一定奉上

Vaet · 发表于 2018-2-24 12:01

2楼大神.如果我的条件是多对多怎么写啊？比如:=SUM(COUNTIFS(C:C,{"是","否"},B:B,{"领班级","员工级","主管级"}))
因为条件很多.
=SUM(COUNTIFS(C:C,"是",B:B,{"领班级","员工级","主管级"}))+SUM(COUNTIFS(C:C,"否",B:B,{"领班级","员工级","主管级"}))+...+这样太麻烦了.有没有简便的方法呢？

Look我在这 · 发表于 2018-2-24 14:25

?
=SUM(COUNTIFS(C:C,{"是";"否"},B:B,{"领班级","员工级","主管级"}))

Look我在这 · 发表于 2018-2-24 14:27

Vaet 发表于 2018-2-24 12:01
2楼大神.如果我的条件是多对多怎么写啊？比如:=SUM(COUNTIFS(C:C,{"是","否"},B:B,{"领班级","员工级","主 ...

这样试试，
=SUM(COUNTIFS(C:C,{"是";"否"},B:B,{"领班级","员工级","主管级"}))

		自动登录	找回密码
密码			免费注册

[求助] 求教countifs函数，一个区域，多个条件“和”的关系，怎么写公式简便