B2=SUMPRODUCT(TEXT(LEFT(TEXT(MID(A2&"A",ROW($1:$1000),COLUMN($A:$P)),),COLUMN($A:$P)-1),"G/通用格式;-G/通用格式;0;!0")*ISERR(-MID(A2,ROW($1:$1000)-1,2)))
ctrl+shift+enter结束
