B3:B5{=SUM(RIGHT(SMALL(IF(VLOOKUP(B$2,$C:$P,ROW($2:$14),)<>"",ROW($2:$14)*10^8+VLOOKUP(B$2,$C:$P,ROW($2:$14),)),ROW(INDIRECT("1:"&LEFTB(A3,2)))),8)*1)
另解=LOOKUP(LEFTB(A3,2)*1,SUBTOTAL({2,9},OFFSET($C$1,MATCH(B$2,C:C,)-1,,,ROW($1:$50))))
另解{=SUM(OFFSET(C$1,MATCH(B$2,C:C,)-1,MATCH(1=1,OFFSET(D$1:P$1,MATCH(B$2,C:C,)-1,)<>"",),,LEFTB(A3,2)))
留言
張貼留言