| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Controlling Cells included in a sum command
Hi,
I need to be able to control the cells that are summed by a number in another cell. My current sum statement is =SUM (L102,T102,X102,AD102,AJ102). I need to use the value is cell A1 to indicate how many of the summed cells to included. For instance if A1=1 then cell L102 is included in the sum. If A1=2 then L102 and T102 would be included in the sum. Any help would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Avoiding cells being included in a chart | Excel Programming | |||
| command button controlling a range of dates | Excel Programming | |||
| Cells not included in formulas | Excel Discussion (Misc queries) | |||
| Range of variables with the 'floor' command included | Excel Worksheet Functions | |||
| Controlling size of command buttons | Excel Discussion (Misc queries) | |||
Threaded Mode
