# 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

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

#### 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?

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

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

### Forum statistics

1,164,020
Messages
5,834,989
Members
430,331
Latest member
Syed Yasir Hannan

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back