| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sum if contains dependent
I have a range(I2:I225) which contains several figures only some of which
feed to other areas of the workbook. I want to add only those figures that have dependents elsewhere. Is this possible without selecting the cells individually? |
|
#2
|
|||
|
|||
|
Create another column that only grabs those fields and autosum that column.
"StephanieH" wrote: I have a range(I2:I225) which contains several figures only some of which feed to other areas of the workbook. I want to add only those figures that have dependents elsewhere. Is this possible without selecting the cells individually? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation - Create dependent lists | Excel Discussion (Misc queries) | |||
| 1-variable Data Table dependent on MS Query fails to update correctly | Excel Discussion (Misc queries) | |||
| Trace ALL dependent cells in any worksheet anywhere in Excel | Excel Worksheet Functions | |||
| Using Validation List from Another Workbook with Dependent Data | Excel Worksheet Functions | |||
| Dependent List Query | Excel Worksheet Functions | |||
Linear Mode
