ExcelBanter - Return values that sum to a known value

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Return values that sum to a known value (https://www.excelbanter.com/excel-worksheet-functions/264756-return-values-sum-known-value.html)

lmattern

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.

Tom-S[_2_]

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.

bala_vb

Quote:

Originally Posted by lmattern (Post 956633)

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.

it would be better if you post the query with example and more assumptions.

All times are GMT +1. The time now is 12:40 AM.