A stupid summing problem - help!
Posted by Rob Field on August 13, 2001 4:47 AM
Guys - I can't for the life of me get my head round this problem. Column A contains a list of numbers, a lot with duplicates and multiple duplicates, column B has values. All I want to do is sum the values in column B corresponding to the values in column A. Ie. Col A may have 1001,1001,1002,1002,1002,1002,1003 etc. Col B has 1,2,1,1,1,2,1. All I want to do is have 1001 = 3, 1002 = 5, 1003 = 1 etc - I'm just summing the Col B values where the Col A values are the same. Thing is, I can do it in my head, but not on the worksheet - any help would be gratefully received.