L lmattern May 27, 2010 #1 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.
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.
T Tom-S May 28, 2010 #2 Have a look at this thread for something similar: http://www.microsoft.com/office/com...rosoft.public.excel.worksheet.functions&fltr= Regards, Tom
Have a look at this thread for something similar: http://www.microsoft.com/office/com...rosoft.public.excel.worksheet.functions&fltr= Regards, Tom