Sum Formula Based Off Text

[DShack]

Hello...

I have a list of text fields that have several names with numbers associated to each one of them of which i'm trying to sum and lookup onto another sheet that has the same text field but only one of them. For example.
[TABLE="width: 206"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Travel Offices[/TD]
[TD]4,564[/TD]
[/TR]
[TR]
[TD]Travel Offices[/TD]
[TD] 175,048[/TD]
[/TR]
[TR]
[TD]Travel Offices[/TD]
[TD] 67,534[/TD]
[/TR]
[TR]
[TD]Travel Offices[/TD]
[TD] 17,278[/TD]
[/TR]
[TR]
[TD]Travel Offices[/TD]
[TD] 51,040[/TD]
[/TR]
[TR]
[TD]Travel Offices[/TD]
[TD] 5,267[/TD]
[/TR]
[TR]
[TD]Travel Offices[/TD]
[TD] 2,293

[/TD]
[/TR]
</tbody>[/TABLE]


But i want to be able to sum all of these into one line that reads Travel Offices but on another tab within Excel. Is this possible. There are several lines that are similar to this...another example:

Search 19,254
Search 1,284
Search 7,618

I tried an index match formula but i need to add something else to this but i'm not sure what. Please help.

 

[AhoyNC]

Try this.
Copy the column with the duplicate names into another tab.
Then under the DATA ribbon use REMOVE DUPLICATES to get a unique list.
Then use SUMIF to add the data.

Excel Workbook
	A	B
1	Travel Offices	323,024
2	Search	28,156
Sheet 2

Excel Workbook
	A	B
1	Travel Offices	4,564
2	Travel Offices	175,048
3	Travel Offices	67,534
4	Travel Offices	17,278
5	Travel Offices	51,040
6	Travel Offices	5,267
7	Travel Offices	2,293
8	Search	19,254
9	Search	1,284
10	Search	7,618
Sheet 1