数组求和

不明所以丢了个账号

35=sum(4,5,5,3,4,5,5,4),您的计算结果是9

夏目志德

<3位置，这个具体什么意思?不是前两个数字4、5求和吗？

我在冰点

计小于3之首数
=SUM(INDEX({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},N(IF({1},ROW(INDIRECT("1:"&MATCH(1=1,{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,)))))))

不计小于3之首数
=SUM(INDEX({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},N(IF({1},ROW(INDIRECT("1:"&MATCH(1=1,{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))))))

世上事

是这个意思？
从第一个数到数字首次小于3的那个位置之间的各数求和，但1应该也不能算吧？！

杨轶

是的，是小于数据3之前的各数据之和，1<3,我搞错了，结果应该是35，谢谢。

少不了

您的计算结果是36，正确结果应该是35

咸闲嫌弦贤

=MMULT({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},(ROW(1:30)<MATCH(1,FREQUENCY(1,({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),))*1)

玖芬月晞

局限性明显，比如把数组改一下，{4,5,5,3,4,1,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位置，这个具体什么意思?不是前两个数字4、5求和吗？

顺通达

计小于3之首数
=SUM(INDEX({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},N(IF({1},ROW(INDIRECT("1:"&MATCH(1=1,{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,)))))))

不计小于3之首数
=SUM(INDEX({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},N(IF({1},ROW(INDIRECT("1:"&MATCH(1=1,{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))))))