| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I add down a list a specified number of cells?
I have a huge number of lists that I am calculating. I have a vertical list
of numbers each vertical cell represents a week. I am trying to add up a varing number of week forward to madel stock controls. Currently I am adding up each individual cell for the number of week that i need (ie 4 weeks is =sum(a2+a3+a4+a5). This is very clumsy and time consuming. Is there a way to write a formula that adds up a specified number of cells forward. i.e add ten cells down the list and return total? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to know the number of times "fam" appears in a list of cells | Excel Discussion (Misc queries) | |||
| How do I number the cells when I am making a list? | Excel Worksheet Functions | |||
| How do i set up a list that sorts as Number/letter/number in orde | Excel Discussion (Misc queries) | |||
| change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
| How do I count the number of cells in a list, e.g. H6:H12, J4, J7: | Excel Worksheet Functions | |||
Threaded Mode
