| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sum of Variable Cells in a fixed Row
I am stuck with this dilemma please help I need to sum cells a row with a variable range that is dependent of a number a user of the work sheet types.
Cell A1: __ User Defined Variable {1,2,3 ect.) Column A B C D E F Row2 5 7 8 5 3 2 Sum A2:C2 if User defined Variable is 3 Row3 4 1 7 5 9 6 Sum A3:E3 if User defined Variable is 4 Row4 1 5 7 8 5 7 Sum A4:B4 if User defined Variable is 2 Please help Tks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How fill series containing one variable and one fixed value in XL | Excel Discussion (Misc queries) | |||
| percent of a fixed and variable number | Excel Discussion (Misc queries) | |||
| Fill variable number of cells with a fixed text | Excel Programming | |||
| Fixed column- Variable row # | Excel Discussion (Misc queries) | |||
| From a fixed cell to a variable | Excel Programming | |||
Threaded Mode
