数组求和

郑旭辉

=MAX(MMULT(--TEXT({4,5,5,3,4,5,5,4,1,2,2,4,3,2,3,4,3,5,4,4,3,3,4,3,5,2,5,5,4,3},"[<3]-1!0!00;0"),N(ROW(1:30)<COLUMN(A:AD))))

用户海角以远

-9!e9应该会更通用些

海阔天晴

对对！
做复杂了，虽然初衷是好的。

阿德金森

我看是小于3 数值出现之前的值 相加
=MAX(,MMULT(--TEXT({4,5,5,3,4,5,5,4,1,2,2,4,3,2,3,4,3,5,4,4,3,3,4,3,5,2,5,5,4,3},"[<3]-9!E9"),N(ROW(1:30)<COLUMN(B:AE))))

敢动中国

=SUM(FILTERXML(CONCAT("<a>0","<b>"&{4,5,5,3,4,5,5,4,1,2,2,4,3,2,3,4,3,5,4,4,3,3,4,3,5,2,5,5,4,3}&"</b>","</a>"),"a|//b[.|preceding::*<3=0]"))

冰之诺言

=MAX(,MMULT(--TEXT({1,5,5,3,4,5,5,4,1,2,2,4,3,2,3,4,3,5,4,4,3,3,4,3,5,2,5,5,4,3},"[<3]-9!E9"),N(ROW(1:30)<COLUMN(B:AE))))
这个逗号 看起来不能少 。。。
是我看错了，只按我的方法计算， 大佬的公式是正确的！
=MAX(MMULT(--TEXT({1,5,5,3,4,5,5,4,1,2,2,4,3,2,3,4,3,5,4,4,3,3,4,3,5,2,5,5,4,3},"[<3]-9!E9"),N(ROW(1:30)<COLUMN(A:AE))))

辋川河

=MAX(MMULT(--TEXT({1,5,5,3,4,5,5,4,1,2,2,4,3,2,3,4,3,5,4,4,3,3,4,3,5,2,5,5,4,3},"[<3]-9!E9"),N(ROW(1:30)<COLUMN(A:AE))))

升起的太阳

=SUM(--MID(LEFT(SUBSTITUTE(CONCAT(TEXT({4,5,5,3,4,5,5,4,1,2,2,4,3,2,3,4,3,5,4,4,3,3,4,3,5,2,5,5,4,3},"[<3]j")),"j",REPT(0,22)),22),ROW(1:22),1))

个位数求和

飘忽若月

不太理解36是怎么得出的。。。
=SUM(--TEXT({4,5,5,3,4,5,5,4,1,2,2,4,3,2,3,4,3,5,4,4,3,3,4,3,5,2,5,5,4,3},"[<3]0;!0"))

狼崽

不太理解36是怎么得出的。。。
=SUM(--TEXT({4,5,5,3,4,5,5,4,1,2,2,4,3,2,3,4,3,5,4,4,3,3,4,3,5,2,5,5,4,3},"[<3]0;!0"))