|1 - Make sure there is a Column header in A1, e.g. "Titles"|
2 - Select the header and titles in Column A, e.g. A1:A100
3 - Click on the Data ribbon then Advanced in the Filter area.
4 - Select the "Copy to another location" and "Unique Records only" choices.
5 - Enter a cell location in the "Copy to" field, e.g. C1.
This will create a list of the unique titles found in Column A and place it in Column C.
6 - In D2 use the SUMIF function, e.g.
Make sure that the range chosen for Column A and B are the same length.
7 - Drag the SUMIF formula down to the bottom of the list in Column C
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.