Excel: Formula to find a specfic value

[brobert95]

Hello. I have a sheet that has multiple cells containing various amounts and use a simple formula to get a value. I can enter a value in A1 and it will subtract A2:A5 from A1 and give me the result in B1. What I need though is a formula that will tell me what value to enter in A1 to always get a result of 5 in B1. Is this possible? Thanks in advance for any help.

 

[gnaga]

What is the formula you entered in B1?

 

[brobert95]

Right now it's just =A1-A2-A3-A4-A5

 

[Eric W]

=SUM(A2:A5)+5

 

[brobert95]

=SUM(A2:A5)+5

I think I was overthinking that one. Thanks so much for your help!