本帖最后由 micch 于 2019-11-7 08:23 编辑
- =SUM(IF(MID(A2&A3&A4&A5&A6,ROW(1:222),1)=C1:F1,LEFT(SUBSTITUTE(ENCODEURL(SUBSTITUTE(SUBSTITUTE(MID(A2&A3&A4&A5&A6,ROW(2:223),22),"收",),"放","-")),"%",REPT(" ",22)),22),)*C10:F10)
复制代码
=SUM(IF(MID(A2&A3&A4&A5&A6,ROW(1:222),LEN(C1:F1))=C1:F1,LEFT(SUBSTITUTE(ENCODEURL(SUBSTITUTE(SUBSTITUTE(MID(A2&A3&A4&A5&A6,ROW(1:222)+LEN(C1:F1),22),"收",),"放","-")),"%",REPT(" ",22)),22),)*C10:F10)
绕不开A列连接再拆分
学习一个暴力定位
- =SUM(C10:F10*TEXT(SUBSTITUTE(SUBSTITUTE(MID(A2&A3&A4&A5&A6,ROW(1:334),FREQUENCY(-ROW(1:333),-IF(MMULT(1-ISERR(-({"",0}&MID(0&A2&A3&A4&A5&A6,ROW(1:333)+{0,1},1))),{1;-1})=1,ROW(1:333),))),C1:F1&"收",),C1:F1&"放","-"),"[<>];;;!0"))
复制代码
|