Finding the right function

viljamil 

As far as I could gather from the text, you could use two possible methods for this.

Using a pivot table:

1. Open a new spreadsheet in Excel.
2. Enter your data into the spreadsheet with one column for names and one column for numbers.
3. Select all the data you entered.
4. Click on the “Insert” tab and select “Pivot Table”.
5. In the pivot table editor, select the name column as your “Rows” and the number column as your “Values”. Make sure to select “Sum” as the aggregation function for the number column.
6. The pivot table will now display each unique name once with the sum of all the numbers associated with that name.

Using a formula:

1. Open a new spreadsheet in Excel.
2. Enter your data into the spreadsheet with one column for names and one column for numbers.
3. In a new column, enter each unique name once.
4. In the cell next to the first unique name, enter the formula =SUMIF(range, criteria, sum_range), where range is the range of cells containing the names, criteria is the cell containing the unique name, and sum_range is the range of cells containing the numbers. For example, if your names are in column A and your numbers are in column B, and your first unique name is in cell D2, you would enter =SUMIF(A:A,D2,B:B) in cell E2.
5. Drag the formula down to fill in the rest of the cells next to each unique name.

Both methods will give you a list of each unique name with the sum of all the numbers associated with that name.

If this is not what you are looking for, please include the following info to help others answer your question (click on link):

Welcome to your Excel discussion space!

I hope this helps! 

NikolinoDE

I know I don't know anything (Socrates)