| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return values that sum to a known value
I have a list of data and would like to know if there is a formula that would
return any items from that list that sum to a known value. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return values that sum to a known value
Have a look at this thread for something similar:
http://www.microsoft.com/office/comm...ctions&f ltr= Regards, Tom "lmattern" wrote: I have a list of data and would like to know if there is a formula that would return any items from that list that sum to a known value. |
|
#3
|
|||
|
|||
|
Quote:
__________________
Thanks Bala |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
| Help with return values on IF/THEN | Excel Discussion (Misc queries) | |||
| How do I use LOOKUP to return a range of values, then SUM values? | Excel Worksheet Functions | |||
| find largest values, then return corresponding row values. | Excel Discussion (Misc queries) | |||
| Search multiple values to return single values | Excel Worksheet Functions | |||
Linear Mode
