Is there a SUMIF or SUMPRODUCT formula that can help me?

[otisvillain]

Hey all-

Here is my dilemma. I have a data set that has account numbers in column A and ending balance numbers in column B. I have a variance of $201,697 between 2 reports. There are hundreds of lines of data. It is set up like this:



Acct Balance
50000 22,300
51100 10,000
52122 12,333

Is there a formula that I can use that says sum column B only if the numbers would total $201,697? I can't seem to find an answer in my research. Thanks folks.

Otisvillain

 

[Joe4]

Maybe this will help: http://www.k2e.com/tech-update/tips/147-using-excel-to-identify-entries-that-add-to-a-specific-value