| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Formula with variable range
I need to calculate the moving average in column C for a long list of numbers
in Colum B. If the variable is in cell A1 and it = 3, then each sum formula should sum a range of the rows, such as; Sum($B$1:$B3), A1 is changed to 5, then Sum($B$1:$B5), where the variable in cell A1 is the row number of end of the range. How can this be accomplished? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula based on variable range | Excel Worksheet Functions | |||
| Variable Range for NPV | Excel Worksheet Functions | |||
| how to specify a range that is variable. | Excel Worksheet Functions | |||
| Excel Named Formula Weakly Interacts with a Variable Range on the Worksheet - Re-Visit | Excel Discussion (Misc queries) | |||
| Variable Determines Number of Cell in Formula Range | Excel Worksheet Functions | |||
Threaded Mode
