202210041542取品牌下面销售合计 (10575)

G2 {=IFERROR(INDEX(C:C,MIN(IF(MATCH(F2,A:A,)<(B$2:B$18="合计")*ROW($2:$18),ROW($2:$18)))),"")

另解=IFERROR(VLOOKUP("合计",INDEX(B:B,MATCH(F2,A:A,)):C99,2,),"")

另解{=SUM((LOOKUP(ROW($2:$18),ROW($2:$18)/(A$2:A$18<>""),A$2:A$18)=F2)*(B$2:B$18="合计")*C$2:C$18)

另解{=IFERROR(INDEX(C:C,SMALL(IF(B$2:B$18="合计",ROW($2:$18)),SUM(N(MATCH(F2,A:A,)>=IFERROR(MATCH(F$2:F$5,A:A,),""))))),"")

另解=IFERROR(VLOOKUP("合计",OFFSET(B$1:C$1,MATCH(F2,A:A,),,99),2,),"")

沒有上一則|日誌首頁|沒有下一則
回應
關鍵字
    沒有新回應!
    blank