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.
 

Some videos you may like

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

Watch MrExcel Video

Forum statistics

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