find numbers in a range that add to a specific value

[Guest]

Jason previously answered the above question with the below answer however I
am looking for a formula that works when adding more than 2 numbers together?
Can anyone help?

thanks, Brett

Assuming your list of numbers are in A1:A50 and the total
number is in F1, try this in B1 and copy down to B50:

=ADDRESS(SUMPRODUCT(--(A1+$A$1:$A$50=$F$1),ROW(INDIRECT("1:50"))),1,4)

If there are any feasible combinations, a cell reference
will appear next to a number. That number, but the number
in the cell reference, will equal the number in F1.

HTH
Jason
Atlanta, GA

 

[Bernd Plumhoff]

If you have to check and/or correct accounts then maybe
this link can help you:

http://www.mrexcel.com/pc09.shtml

HTH,
Bernd