# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Hi i need a formula that will pick up 1 number that can be made up of a number of numbers in another column. ie. in my column E i have a total of Â£2722.00 but a lot of number in column F and need to see if any combination of those numbers make up the Â£2722.00 thanks.
Solved by G. F. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 06/09/2018 - 10:44
Hu
Excelchat Expert 06/09/2018 - 10:44
Hi*
User 06/09/2018 - 10:45
Hi i am looking to see if there is a formula that can work out if the 2722 can be made up of the number on the side in column b
Excelchat Expert 06/09/2018 - 10:46
Got it
Excelchat Expert 06/09/2018 - 10:46
I am working on it
User 06/09/2018 - 10:46
is there a formula that highlights the numebrs that add up to the figure in column a
Excelchat Expert 06/09/2018 - 10:46
Give me some time
Excelchat Expert 06/09/2018 - 10:46
Please stay online and do not worry about the timer, you can extend it twice
Excelchat Expert 06/09/2018 - 11:02
Excelchat Expert 06/09/2018 - 11:02
Hi
Excelchat Expert 06/09/2018 - 11:02
Here it is
Excelchat Expert 06/09/2018 - 11:02
In the sum to target sheet of this excel. I have done what you wanted
Excelchat Expert 06/09/2018 - 11:03
I will explain to you in steps
Excelchat Expert 06/09/2018 - 11:03
In column B you can paste your constituent numbers
Excelchat Expert 06/09/2018 - 11:04
In cell F1 and G1 you can enter your target value minimum and maximum
User 06/09/2018 - 11:05
okay thanks
Excelchat Expert 06/09/2018 - 11:07
In cell b1 enter the count of your constituent numbers
Excelchat Expert 06/09/2018 - 11:07
For example, in the online sheet you have given 8 numbers
Excelchat Expert 06/09/2018 - 11:08
So the cell B1 should read 8
User 06/09/2018 - 11:08
where do i put the 2722
Excelchat Expert 06/09/2018 - 11:09
G1
User 06/09/2018 - 11:09
and if f1?
Excelchat Expert 06/09/2018 - 11:09
F1 can be any number smaller to the target number
User 06/09/2018 - 11:09
do i leave this as 2722
Excelchat Expert 06/09/2018 - 11:09
Then you click on calculate button
Excelchat Expert 06/09/2018 - 11:10
Actually make F1 also as 2722
Excelchat Expert 06/09/2018 - 11:12
It will be better

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.