数组公式兴趣小组练习题--005

xhsdham

<p>谢谢<strong><font face="Verdana" color="#da2549">封州大少</font></strong>版主的指导 这个问题偶先前有所认识 只是糊里糊涂的 下面这样应该算是正确的吧</p><p>G3:G8&nbsp; =SUM(INDEX(TRANSPOSE(A3:D8),,{1;2;3;4;5;6}))</p><p>A10:D10&nbsp;=SUM(INDEX(A3:D8,,{1,2,3,4}))</p>

[此贴子已经被作者于2007-6-6 14:50:19编辑过]

xhsdham

<p>[em06][em06]上面的好像还不是内存数组[em06][em06]</p><p>&nbsp;</p><p>=SUM(IF(ROW($A$3:$D$8)=ROW(),1,0)*$A$3:$D$8)</p>

[此贴子已经被作者于2007-6-6 17:17:53编辑过]

封州大少

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>Luckyguy2008</i>在2007-6-6 14:03:14的发言：</b><br/>大少这两天上网比较频繁，网络问题应该解决了，可喜可贺！</div><p>没办法,没想到这网瘾比烟瘾更难受,只好以戒烟为条件说服老婆大人自己开了个宽带帐号</p>

MXQCHINA

<p>F3:F8=MMULT($A$3:$D$8,TRANSPOSE(COLUMN(INDIRECT("C1:C"&amp;COLUMNS(A3:D8),))*0+1))</p><p>A10:D10=MMULT(COLUMN(INDIRECT("C1:C"&amp;ROWS($A$3:$D$8),))*0+1,$A$3:$D$8)</p><p>第二题再想想</p>

MXQCHINA

K19=SUMPRODUCT((SUM(($B19:$J19*10^(10-COLUMN($B$19:$J$19))))&lt;MMULT($B$19:$J$29*10^(10-COLUMN($B$19:$J$19)),ROW(INDIRECT("1:9"))*0+1))*1)+1

xhsdham

不用MMULT 好像更有意思

lws

<p>横向=SUMIF(OFFSET($A$3:$A$8,,COLUMN($A:$D)-1,),"&gt;0")</p><p>纵向=SUMIF(OFFSET($A$3:$D$3,ROW(A$1:A$6)-1,),"&gt;0")</p>

MXQCHINA

<p>F3=SUBTOTAL(9,OFFSET($A$2:$D$2,ROW(INDIRECT("1:"&amp;ROWS($A$3:$D$8))),))</p><p>A10=SUBTOTAL(9,OFFSET($A$3:$A$8,,COLUMN(INDIRECT("C1:C"&amp;COLUMNS($A$3:$D$8),))-1))</p><p>&nbsp;</p>

xinanjiang

<p>F3:F8=SUM(INDIRECT("A"&amp;ROW()&amp;":d"&amp;ROW()))</p><p>A10:D10=SUM(INDIRECT(ADDRESS(3,COLUMN())&amp;":"&amp;ADDRESS(8,COLUMN())))</p>

szyygb

学习，受益匪浅