Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() Because I am studying in depth the array formulas, I would like to know if it is possible to build a formula such that, given a set of numbers in a vertical range (1 column wide), it returns an array with the cumulative sum. For example, if A1:A5 contains: 3 8 5 1 6 Then, the formula should return 3 11 16 17 23 Of course, I know that the goal can be achieved by mean of a simple formula: =SUM($A$1:A1) copied down However, I keep an interest (let's call it theoretical) in knowing if the exercise is possible? Can anybody help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Returning an Array from a called function within a macro | New Users to Excel | |||
Returning an address from an array | Excel Discussion (Misc queries) | |||
Returning an array from the INDEX function | Excel Worksheet Functions | |||
Array formula returning wrong results | Excel Discussion (Misc queries) | |||
Array formula returning terminated employees | Excel Worksheet Functions |