| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| column labels have changed to numbers | Excel Discussion (Misc queries) | |||
| find sum in list of of numbers | New Users to Excel | |||
| find sum in list of of numbers | New Users to Excel | |||
| find sum in list of of numbers | New Users to Excel | |||
| How can I compare a number against a list of numbers | Excel Worksheet Functions | |||
Hybrid Mode
