How to sum duplicate names

[lols888]

Hi Excel experts,

I would need advise for the following:

1) For each of my worksheet, if there is a duplicate in the event name, I would like to sum up the amount (not using pivot table)

2) After which, I want to combine both the data from both worksheet into one new worksheet without duplicate in their name

Thank you in advance!

[alansidman]

1. Sort the range by Events
2. Use the built in Sub total Function found on the Data Tab