函数公式多个区间的怎么写Excel函数,求大神回复。
发布网友
发布时间：2024-10-23 05:28
共1个回答
热心网友
时间：2024-10-23 20:10
G2：
=TEXT(SUMPRODUCT((LEFT($A$2:$A$11,FIND("-",$A$2:$A$11)-1)*1<=E2)*(RIGHT($A$2:$A$11,LEN($A$2:$A$11)-FIND("-",$A$2:$A$11))*1>=E2)*(SUBSTITUTE($B$2:$B$11,"<","")*1>F2),$C$2:$C$11),"0;0;!3")
