Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing a variable number of rows
I want to sum a variable number of rows which is in a column of numeric
information. For example, say the column has entries 1,2,3,4 and 5 in five separate rows. I would like to be able to sum a number of contiguous entries (e.g. sum the second, third and fourth rows, or sum the fourth and fifth rows). This can obviously be done by creating a normal sum function (e.g. =sum(A2:A4) for the first example above). However, if I want to vary where the series is summed from (e.g. A2 or A3) - and the number of rows that are summed (e.g. A2 to A4, or A4 to A5) - I need to go in and manually re-write this formula. Is it possible to have a sum-type formula linked to two input cells, where input cell one indicates where the summed series is to commence from and cell two indicates the umber of rows that are to be summed? Thanking you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cells to variable number of rows | Excel Discussion (Misc queries) | |||
copy down with variable number of rows | Excel Discussion (Misc queries) | |||
Summing a Variable Number of Cells | Excel Discussion (Misc queries) | |||
Linking to a Variable Number of Rows - XP/07 | Excel Worksheet Functions | |||
How do I assign a text value to a variable number of rows? | Excel Worksheet Functions |