本帖最后由 tt0203 于 2016-6-6 20:48 编辑
=SUBSTITUTE(TEXT(SUBSTITUTE(SUM(IFERROR(SMALL(IF(ISNUMBER(MATCH(ROW(1:66)-1,IF(COUNTIF(OFFSET(D5,COUNT(D:D),,-6),OFFSET(D5,COUNT(D:D)-10,,5)),"",OFFSET(D5,COUNT(D:D)-10,,5)),)),ROW(1:66)-1),ROW(1:5))*100^(6-ROW(1:5)),)),"00",),REPT(" 00",COUNT(MATCH(ROW(1:66)-1,IF(COUNTIF(OFFSET(D5,COUNT(D:D),,-6),OFFSET(D5,COUNT(D:D)-10,,5)),"",OFFSET(D5,COUNT(D:D)-10,,5)),))))," 0"," ") 凑一个,快回家吧 |