Excel如何统计在特定时间段内各类别的值?

发布网友发布时间：2023-08-02 09:19

共1个回答

热心网友时间：2023-08-04 06:27

H2=SUMPRODUCT(($A$2:$A$16>=$G$2)*($A$2:$A$16<=$I$2)*($B$2:$B$16=LOOKUP("座",$F$5:$F5))*($C$2:$C$16=$G5)*($D$2:$D$16))
下拉公式
I2=SUMPRODUCT(($A$2:$A$16>=$G$2)*($A$2:$A$16<=$I$2)*($B$2:$B$16=LOOKUP("座",$F$5:$F5))*($C$2:$C$16=$G5))
下拉公式
J5=MIN(IF(($A$2:$A$16>=$G$2)*($A$2:$A$16<=$I$2)*($B$2:$B$16=LOOKUP("座",$F$5:$F5))*($C$2:$C$16=$G5),$D$2:$D$16,""))
数组公式，同时按CTRL SHIFT 回车键
K5=MAX(IF(($A$2:$A$16>=$G$2)*($A$2:$A$16<=$I$2)*($B$2:$B$16=LOOKUP("座",$F$5:$F5))*($C$2:$C$16=$G5),$D$2:$D$16,""))
数组公式，同时按CTRL SHIFT 回车键追问太完美了，所有问题迎刃而解，就是有个问题：lookup里的“座”是啥含义？

追答你有合并单元格，
座，ZUO，就是查找文本的意思