Formula help please

[bthumble]

If I have a list of amounts (with cost centers), is there a way for Excel to tell me if the listed amounts equal a determined total.

Here is a simple example.
Cost Center Amount
1 10
2 12
3 15
4 20

The total of the amounts is 57, but the total I am looking for is 45, so the item that I can delete is 12. Is there any way to have Excel help me with this? The data is from SAP, and I am unable to download only the data that I need, and do not know which cost centers should be ignored.

Thanks for your help.

 

[Oaktree]

There was a previous "challenge of the month" to tackle this very problem.

The official posting/winner is here: http://www.mrexcel.com/pc09.shtml but the discussion here might be of use as well:

http://www.mrexcel.com/forum/showthread.php?t=16533