Hi there,

I have a worksheet like the below

Column A Column B

London 1
Manchester 2
London 3
Derby 3
London 3
Manchester 3

I have a 2nd worksheet with all the names in column A. However I want
the total of column B for each London to be in the 2nd worksheet.

For example, on the 2nd worksheet it would have

London 7
Derby 3
Manchester 5

Any ideas?


--
rtidrtid
------------------------------------------------------------------------
rtidrtid's Profile: http://www.excelforum.com/member.php...o&userid=31148
View this thread: http://www.excelforum.com/showthread...hreadid=508145