| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing a volitile number of cells
I've got a row of numbers A2:K2. I want a formula that will sum from A2 to
the number of cells I enter in A1. So if I enter "3" in cell A1, the formula will sum from A2 to C2. and if I enter "5" in cell A1, it will sum from A2 to E2. I've been fiddling around in R1C1 but not getting it to work... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want the greater number of 2 cells to show in a separate cell | Excel Discussion (Misc queries) | |||
| I want the greater number of 2 cells to show in a separate cel | Excel Discussion (Misc queries) | |||
| I want the greater number of 2 cells to show in a separate cell | Excel Discussion (Misc queries) | |||
| Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
