Adding multiple values against a unique ID?

[DanielS95]

I'm not even sure where to start with this one, so apologies if the title seems a little strange.

I have a report from work that lists all of the outstanding fees people, however, if they have more than one fee outstanding it lists on separate rows. So for example, it will appear like this;

Unique ID	First Name	Surname	Fee Type	Fee
1234	Dan	Smith	Membership Jan	£5
1234	Dan	Smith	Membership Feb	£10
9874	Aaron	Wright	Membership Jan	£5

I want to do a mail merge and send an email to everyone telling them how much is outstanding. Ideally I'd like to have one line per person with a total fee, rather than individual fees per month etc. My spreadsheet is over 1000 rows and some people have 5+ entries, some 1, some 2 etc. How can I total all of the fees based off the unique ID?

If I am barking up the wrong tree and need to do something else entirely, your help would also be appreciated!

Thanks in advance!

 

[J.Ty.]

Copy the column with ID to a new worksheet (I did it below), go to Ribbon->Data->Dta tools->Remove Duplicates.
Then you will have the list of people who should get a mail. Next add formulas which calculate how many fees are outstanding and their total amount.

Book1
	A	B	C	D	E
1	1234	Dan	Smith	Membership Jan	5
2	1234	Dan	Smith	Membership Feb	10
3	9874	Aaron	Wright	Membership Jan	5
4
5
6
7	ID	number of fees	total fees
8	1234	2	15
9	9874	1	5
Sheet4

Cell Formulas
Range	Formula
B8:B9	B8	=COUNTIF($A$1:$A$3,A8)
C8:C9	C8	=SUMIF($A$1:$A$3,A8,$E$1:$E$3)

 

[DanielS95]

Thank you so much!

 

[J.Ty.]

Thanks for the feedback and good luck!

J.Ty.