Problem identifying records that 'Total' to a certain value?

[Rassis]

I think it will be quite a hassle to achieve what you want. All possible combinations will certainly total a huge number! Nevertheless, here is what I would do if I were in your place:

1. Transfer all data (invoice values) into a spreadsheet;
2. Sort in ascending (or descending) order;
3. Select all the invoices whose values are less than £120796.27;
4. Draw a table similar to the one I join herewith with an example (for only 6 invoices). The number of all possible combinations in your case is given by [2^n - 1], where n stands for number of selected invoices – if you have, 100 say, you get (2^100 - 1) - an impossible task!;
5. Assume an upper and a lower acceptable limit for the total of the summation of all the selected invoices;
6. Filter the totals that are between those limits.

The example I add comprises only 6 invoices and, despite the low quantity, the number of all possible combinations is (2^6 -1 ) = 63.

If you really need to go forward with this task, I suggest that you show the example to somebody computer coding literate and perhaps, after understanding the logic behind it, he can conceive a shortcut. On the other hand, if you are involved in an auditing process – which I suspect you are –, please consult a good book on statistics and in particular on this subject. The following title, among others, can be of help “Statistics for Managers” by Levine, David M. et al., Prentice Hall, 1999, 2nd edition (auditing is covered between pages 458 and 463). There are auditing methods well established since long.

Hope this helps.

Rui