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 calculatedAny ideas?????
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.
=SUMIF($A$2:$A$100,C2,$B$2:$B$100)
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.
DerbyDad03,
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