|
<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>Luckyguy2008</i>在2007-9-12 11:32:00的发言:</b><br/>内存数组=LOOKUP(ROW(INDIRECT("1:"&SUM(B2:B4)))-1,<font color="#ff0000">SUM(B2:B4)-SUMIF(OFFSET(B4,,,ROW(B2:B4)-ROW(B4)-1),">0")</font>,A2:A4)<br/><br/></div><p>红色部分只用一个SUMIF就行了。 </p><p>SUMIF(OFFSET(B1,,,ROW(B2:B4)-ROW(B2)+1),">0")</p> |
|