| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Criteria Range result plus x amt of cells
I would like to use each true criteria range result as a reference to find
the cell contents to sum. i.e.True Criteria range result found in C10, Add contents found in cell C17. The cell resulting in "true" from the criteria will be 7 cells above the amount required for SUM ? Can I reference the results of the criteria range and criteria formula as a base location to find the cell with the amount to be summed ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count a range of cells from another columns criteria | Excel Worksheet Functions | |||
| Counting cells in a range per multiple criteria . . . | Excel Worksheet Functions | |||
| Sum.if criteria related to range of cells | Excel Worksheet Functions | |||
| color a range of cells based on a criteria | Excel Discussion (Misc queries) | |||
| Copy range of cells omitting formulas that result in " " | Excel Discussion (Misc queries) | |||
Threaded Mode
