|
G17=IFERROR(INDEX($D$5:$D$14,SMALL(IF((MID($C$5:$C$14,4,1)-0=7)*(MATCH($D$5:$D$14,D:D,)=ROW($D$5:$D$14)),ROW($D$5:$D$14)-4,"/"),ROW(A1))),"") 数组三键执行后下拉复制,直到见到空白,得到去重复后清单
H17=IF(G17="","",SUMPRODUCT(($D$5:$D$14=G17)*(MID($C$5:$C$14,4,1)-0=7)*($E$5:$E$14))) 普通公式执行后下拉复制
|
|