满主的贴子,来来来,来个世界级的火车:
=SUMPRODUCT(TEXT(LEFT(TEXT(MID(SUBSTITUTE(A2:A6&"鱼",C1&"收","鱼"&REPT(" ",21)),COLUMN(A:TM),21),),20),"G/通用格式;;;!0")*C10)
+SUMPRODUCT(TEXT(LEFT(TEXT(MID(SUBSTITUTE(A2:A6&"鱼",C1&"放","鱼"&REPT(" ",21)&"-"),COLUMN(A:TM),21),),20),"G/通用格式;-G/通用格式;;!0")*C10)
+SUMPRODUCT(TEXT(LEFT(TEXT(MID(SUBSTITUTE(A2:A6&"鱼",D1&"收","鱼"&REPT(" ",21)),COLUMN(A:TM),21),),20),"G/通用格式;;;!0")*D10)
+SUMPRODUCT(TEXT(LEFT(TEXT(MID(SUBSTITUTE(A2:A6&"鱼",D1&"放","鱼"&REPT(" ",21)&"-"),COLUMN(A:TM),21),),20),"G/通用格式;-G/通用格式;;!0")*D10)
+SUMPRODUCT(TEXT(LEFT(TEXT(MID(SUBSTITUTE(A2:A6&"鱼",E1&"收","鱼"&REPT(" ",21)),COLUMN(A:TM),21),),20),"G/通用格式;;;!0")*E10)
+SUMPRODUCT(TEXT(LEFT(TEXT(MID(SUBSTITUTE(A2:A6&"鱼",E1&"放","鱼"&REPT(" ",21)&"-"),COLUMN(A:TM),21),),20),"G/通用格式;-G/通用格式;;!0")*E10)
+SUMPRODUCT(TEXT(LEFT(TEXT(MID(SUBSTITUTE(A2:A6&"鱼",F1&"收","鱼"&REPT(" ",21)),COLUMN(A:TM),21),),20),"G/通用格式;;;!0")*F10)
+SUMPRODUCT(TEXT(LEFT(TEXT(MID(SUBSTITUTE(A2:A6&"鱼",F1&"放","鱼"&REPT(" ",21)&"-"),COLUMN(A:TM),21),),20),"G/通用格式;-G/通用格式;;!0")*F10)
虽然非常得土,不过还是工整的,表骂我哈 |