# Finding the sum

#### bcabano

##### New Member
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.

### Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the \$ sign).

#### NBVC

##### Well-known Member
Why are those numbers bold?

Is there a condition that turned them bold?

#### bcabano

##### New Member
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

##### Well-known Member
But how do you determine which are to be bolded and therefore summed up?

#### Aladin Akyurek

##### MrExcel MVP
bcabano said:
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

Replies
16
Views
254
Replies
16
Views
171
Replies
0
Views
64
Replies
7
Views
183
Replies
0
Views
62

Threads
1,118,536
Messages
5,572,767
Members
412,482
Latest member
arooshrana2