Finding the sum

[bcabano]

I am looking for a way to find out what adds up to a single number from a range of numbers. Below is an example of what I am looking for.

Single Items
6.32
9.87
3.25
4.87
5.25
2.46
1.85

Total 17.20

The three items that are bold total up to the 17.20, but how can I get that when the range is larger.

 

[NBVC]

Why are those numbers bold?

Is there a condition that turned them bold?

 

[bcabano]

They are bold just to show which three make up the total amount. I get a list sometimes and a total. The total is made up of several items from that list and I have to try and go through the list and find out which ones make up the total.

 

[NBVC]

But how do you determine which are to be bolded and therefore summed up?

 

[Aladin Akyurek]

They are bold just to show which three make up the total amount. I get a list sometimes and a total. The total is made up of several items from that list and I have to try and go through the list and find out which ones make up the total.

See whether this helps:

http://www.mrexcel.com/board2/viewtopic.php?t=16914