[已解决]符合两个条件求次数及和值

陈瑞云

符合两个条件求次数及和值

三，对应的K6至K3取大于等于3，小于等于15范围
更正为  三，对应的K6至K31取大于等于3，小于等于15范围

最佳答案

月排行榜 / 总排行榜

橘子红

2016-1-1 20:00

h3=

1. =COUNTIFS($E:$E,--H2,$G:$G,">=4",$G:$G,"<=13",$K:$K,">=3",$K:$K,"<=15")

复制代码

h4=

1. =SUMIFS($K:$K,$E:$E,--H2,$G:$G,">=4",$G:$G,"<=13",$K:$K,">=3",$K:$K,"<=15")

复制代码

跳转到最佳答案楼层

橘子红

h3=

1. =COUNTIFS($E:$E,--H2,$G:$G,">=4",$G:$G,"<=13",$K:$K,">=3",$K:$K,"<=15")

复制代码

h4=

1. =SUMIFS($K:$K,$E:$E,--H2,$G:$G,">=4",$G:$G,"<=13",$K:$K,">=3",$K:$K,"<=15")

复制代码

橘子红

附件

hysys32

=INDEX($G$6:$G$31,SMALL(IF(($E$6:$E$31=R15)*($G$6:$G$31>=4)*($G$6:$G$31<=13)*($K$6:$K$31>=3)*($K$6:$K$31<=15),ROW($A$1:$A$26)),COUNTIF(R$15:R15,R15)))
见附件