<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>xhsdham</i>在2007-6-6 1:43:04的发言:</b><br/><p>G3:G8 =SUM(OFFSET(A3:D8,ROW(INDIRECT("1:"&ROWS(A3:D8)))-1,,1,COLUMNS(A3:D8)))</p><p>A10:D10 =SUM(OFFSET(A3:D8,,COLUMN(INDIRECT("1:"&COLUMNS(A3:D8)))-1,ROWS(A3:D8),1))</p></div><p>xhsdham版主对内存数组的理解还不大正确,公式的结果不是内存数组,请参考以一链接中FOX老师对内存数组的解释 </p><p><strong><em><a href="http://www.excelpx.com/dispbbs.asp?BoardID=117&replyID=60871&id=13292&skin=0">http://www.excelpx.com/dispbbs.asp?BoardID=117&replyID=60871&id=13292&skin=0</a></em></strong></p>
[此贴子已经被作者于2007-6-6 12:05:49编辑过] |