**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

[Uploaded an Excel file]

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.*