對字符串中大於4的數字求和
本帖最后由 心正意诚身修 于 2016-3-20 00:19 编辑已知有50字符以內答案.
貼代碼即可,
佔樓 =SUM(TEXT(MID(A3,ROW($1:99),1),"[>4]0;;!0;!0")*1) 搜的:lol=SUMPRODUCT(--(0&TEXT(MID(A3,ROW($1:$99),1),"[>4];;;"))) =SUM(1*(0&TEXT(MID(A3,ROW($1:19),1),"[>4]0;;;")))
=SUM((LEN(A3)-LEN(SUBSTITUTE(A3,ROW($5:$9),)))*ROW($5:$9))
页:
[1]