[开_138]共有多少种求和方法

tsoyzm

都是神人，学习了

孙振友

数学学得不好，没办法啊。有的公式根本就理解不了。

piny

piny 发表于 2012-11-21 16:34
嗯 subtotal函數的寫法僅算一種

很快的偷看hjj0451老師的作品，

wangg913  
他的是否可算42个正确？  
hjj0451的，LINEST 和 SLOPE 以及 XNPV 为何多写了，这三个不算吗？

應該是43個，subtotal只算一次，其餘OK

小弟是指他寫的公式和我寫的公式只有這幾式不一樣，他有多寫到這幾種寫法，而我則是多寫到那幾種寫法

若合併起來看，此題至少有47種函數解(其餘老師的答案未細看 ><)

piny

hjj0451 发表于 2012-11-14 15:36
更新为44种，挑战无止境，题目很有意义：

理论上MDETERM和STEYX/C ...

財富部分，由於我一次只能給到50財富分，是否可以請權限較大的版主們協助加財富

piny

piny 发表于 2012-11-26 13:13
財富部分，由於我一次只能給到50財富分，是否可以請權限較大的版主們協助加財富

呵 對耶 計42個

剛好與小弟平手 ><

wangg913

=AGGREGATE(1,,G2:K2)*5

=AVEDEV(G2:K2*{1;-1})*5

=AVERAGE(G2:K2)*5

=AVERAGEA(G2:K2)*5

=AVERAGEIF(G2:K2,">0")*5

=AVERAGEIFS(G2:K2,G2:K2,">0")*5

=COUNT(1/(G2:K2>={1;2;3;4;5;6;7;8;9;10;11;12;13;14;15;16;17;18;19;20}))

=COVAR(G2:K2^0.5*{1;-1},G2:K2^0.5*{1;-1})*5

=COVARIANCE.P(G2:K2^0.5*{1;-1},G2:K2^0.5*{1;-1})*5

=COVARIANCE.S(G2:K2^0.5*{1;-1},G2:K2^0.5*{1;-1})*9/2

=DEVSQ(G2:K2^0.5*{1;-1})/2

=FORECAST(,G2:K2,{1,-1,0,0,0})*5

=FREQUENCY(--({1;2;3;4;5;6;7;8;9;10;11;12;13;14;15;16;17;18;19;20}>G2:K2),0)

=HARMEAN(G2:K2^-1)^-1*5

=--IMSUM(G2:K2)

=INTERCEPT(G2:K2,{1,-1,0,0,0})*5

=LINEST(G2:K2*{1;-1},{1,1,1,1,1}*{1;-1})*5

=MMULT(G2:K2,{1;1;1;1;1})

=NPV(0,G2:K2)

=PROB({1,2,3,4,5}*{1;0},G2:K2*{1;-1}+{0,0,0,0,1}*{0;1},1,5)

=SERIESSUM(1,2,0,G2:K2)

=SLOPE(G2:K2*{1;-1},{1,1,1,1,1}*{1;-1})*5

=STDEV(G2:K2^0.5*{1;-1})^2*4.5

=STDEV.P(G2:K2^0.5*{1;-1})^2*5

=STDEV.S(G2:K2^0.5*{1;-1})^2*4.5

=STDEVA(G2:K2^0.5*{1;-1})^2*4.5

=STDEVP(G2:K2^0.5*{1;-1})^2*5

=STDEVPA(G2:K2^0.5*{1;-1})^2*5

=SUBTOTAL(1,G2:K2)*5

=SUBTOTAL(9,G2:K2)

=SUM(G2:K2)

=SUMIF(G2:K2,">0")

=SUMIFS(G2:K2,G2:K2,">0")

=SUMPRODUCT(G2:K2)

=SUMSQ(G2:K2^0.5)

=SUMX2MY2(G2:K2^0.5,G2:K2*0)

=SUMX2PY2(G2:K2^0.5,G2:K2*0)

=SUMXMY2(G2:K2^0.5,G2:K2*0)

=TREND(G2:K2,{1,-1,0,0,0},0)*5

=TRIMMEAN(G2:K2,0)*5

=VAR(G2:K2^0.5*{1;-1})*4.5

=VAR.P(G2:K2^0.5*{1;-1})*5

=VAR.S(G2:K2^0.5*{1;-1})*4.5

=VARA(G2:K2^0.5*{1;-1})*4.5

=VARP(G2:K2^0.5*{1;-1})*5

=VARPA(G2:K2^0.5*{1;-1})*5

=XNPV(1E-307,G2:K2,365*{0,1,2,3,4}+1)

20121126-七天乐之有多少种求和方法.rar (9.79 KB, 下载次数: 58)

2012-11-26 13:38 上传

点击文件名下载附件

xuxing7712

=SUM(G2:K2)
=SUMIF(G2:K2,"<>")
=SUMPRODUCT(G2:K2)
=SUBTOTAL(9,G2:K2)
=AGGREGATE(9,,G2:K2)
=SUBTOTAL(1,G2:K2)*5
=AGGREGATE(1,,G2:K2)*5
=AVERAGEA(G2:K2)*5
=AVERAGE(G2:K2)*5
=SUMXMY2(G2:K2^0.5,G2:K2*0)
=SUMX2MY2(G2:K2^0.5,G2:K2*0)
=SUMX2PY2(G2:K2^0.5,G2:K2*0)
=SUMSQ(G2:K2^0.5)
=--IMSUM(G2:K2)
=SERIESSUM(1,0,0,G2:K2)
=MMULT(G2:K2,{1;1;1;1;1})
=5/HARMEAN(1/G2:K2)
=TRIMMEAN(G2:K2,)*5
=NPV(,G2:K2)
=XNPV(1E-307,G2:K2,365*{0,1,2,3,4}+1)
=AVEDEV(G2:K2*{1;-1})*5
=DEVSQ(G2:K2^0.5*{1;-1})/2
=STDEV(G2:K2^0.5*{1;-1})^2*4.5
=STDEV.S(G2:K2^0.5*{1;-1})^2*4.5
=STDEVP(G2:K2^0.5*{1;-1})^2*5
=STDEV.P(G2:K2^0.5*{1;-1})^2*5
=STDEVA(G2:K2^0.5*{1;-1})^2*4.5
=STDEVPA(G2:K2^0.5*{1;-1})^2*5
=VAR(G2:K2^0.5*{1;-1})*4.5
=VAR.S(G2:K2^0.5*{1;-1})*4.5
=VARP(G2:K2^0.5*{1;-1})*5
=VAR.P(G2:K2^0.5*{1;-1})*5
=VARA(G2:K2^0.5*{1;-1})*4.5
=VARPA(G2:K2^0.5*{1;-1})*5
=COVAR(G2:K2^0.5*{1;-1},G2:K2^0.5*{1;-1})*5
=SUMIFS(G2:K2,G2:K2,"<>")
=AVERAGEIF(G2:K2,"<>")*5
=AVERAGEIFS(G2:K2,G2:K2,"<>")*5
=SLOPE(G2:K2*{1;-1},{1,1,1,1,1}*{1;-1})*5

丢丢表格

hjj0451 发表于 2012-11-14 15:36
更新为44种，挑战无止境，题目很有意义：

理论上MDETERM和STEYX/C ...

我怎么看都看不出来意义在哪？？
那这个 =IF(1,G2+H2+I2+J2+K2)  这个算吗？
还有：=N(G2+H2+I2+J2+K2)

  有点闲得慌啊！

lpy6666

都是神人，学习了

素锦流年つ

看完此帖，我只能说，原来我连求和都没学会。。。
都是大师啊{:soso_e179:}