finding differences in a list of amounts

["Dan Bale" <dbale@xxxxxxxxxxxxx>]

(Cross posting to midrange-l, rpg400-l)

Anybody know of a solution for this?

I have a user that tells me that a report she is getting has the wrong total
amount.  The report shows the detail (a lot of it) but her total that she
keeps track of in a spreadsheet is different from the report's.  Her
spreadsheet doesn't have the detail.  Here's what I have:

$384,582.91 = the report total
$371,448.26 = the user's total
-----------
$ 13,134.65 = difference

Unfortunately, I do not have a single amount of 13,134.65 in my detail.  So,
I must have multiple amounts that total to 13,134.65.

The solution I am looking for is to be able to try all the combinations in
the detail to see what turns up equal to a given total amount.  For example,
if I have the following detail:
     185.69
  11,134.60
     500.03
   4,841.65
   1,500.02
     419.85
etc.
A good tool would be able to find that the 2nd, 3rd, and 5th amounts add up
to the total amount I'm looking for.

Does Excel have a function for something like this?  Or is there to do it on
the 400?  SQL functions?

tia,
db