ExcelBanter - sum up a dynamic-changed list of numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sum up a dynamic-changed list of numbers (https://www.excelbanter.com/excel-discussion-misc-queries/73258-sum-up-dynamic-changed-list-numbers.html)

minrufeng

sum up a dynamic-changed list of numbers

for example:

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

A8:not empty
A9:not empty

Flintstone

sum up a dynamic-changed list of numbers

Try this

=SUM(INDIRECT("A1:A"&ROW()))

Matt

--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
View this thread: http://www.excelforum.com/showthread...hreadid=515423

All times are GMT +1. The time now is 03:35 AM.