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
全站熱搜