I am assuming this is for business deductions on a tax return...Here is the quick and dirty way I would do it:
1. Sort the receipts in column A
2. Add the receipts is column B
3. If yer lucky, one of the sums will be the exact number
4. If not lucky, select the receipts that get closest to the total
5. Call it a day, let the IRS figure the details out
.
Good thing I am not a CPA
.