Solved Total values relating to a list of titles

February 7, 2014 at 09:37:40
Specs: Windows 7
Hi guys, been a while but I need some help to get me back in the swing of things.

I have two columns, Column A is a list of titles, column B is a list of values

In column A, the titles are varied and many, and several are identical. This is a random listing

Each title will, in column B have a value from 0 upwards

What I would like to be able to do is total the values for a specific title,

Lets say that column A has 1000 entries and Column B has the same. Column A has 50 titles randomly placed within the 1000 entries and column B has 1000 different values
I need to be able to state a title, and the total value to be calculated

Any ideas?????

See More: Total values relating to a list of titles

Report •

February 7, 2014 at 12:17:04
✔ Best Answer
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.

Report •

February 13, 2014 at 09:43:39
Many thanks for your response and answer.
Its been a while but with your help and a little bit of manufacturing, I got the required action for the spreadsheet I am working on

Report •

Related Solutions

Ask Question