Finding the sum

bcabano

New Member
Joined
Dec 12, 2005
Messages
4
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
Joined
Aug 31, 2005
Messages
5,828
Why are those numbers bold?

Is there a condition that turned them bold?
 

bcabano

New Member
Joined
Dec 12, 2005
Messages
4
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
Joined
Aug 31, 2005
Messages
5,828
But how do you determine which are to be bolded and therefore summed up?
 
Master Excel Bundle

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

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top