| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
lookup and return range of cells
I want to find the sum of a range of values in a table, but I want this range
to be set by a lookup function. My data table has numerous entries for each value I want to lookup (say there are 21 matches of value "a", and then I want to sum up what corresponds to all those "a" values.). Any help? Let me know if you need more info. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match function...random search? | Excel Worksheet Functions | |||
| Return cell reference of lookup value | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Can I use formulas that return cell range ref. in charts X series | Charts and Charting in Excel | |||
Threaded Mode
