close

for example:

A1: 10
A2:5
A3:4
A4:11
A5:1
A6:sum(A1:A5)

A8:not empty
A9:not empty


Try this

=SUM(INDIRECT(quot;A1:Aquot;amp;ROW()))

Matt--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: www.excelforum.com/member.php...oamp;userid=15310
View this thread: www.excelforum.com/showthread...hreadid=515423

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()