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.
Rgds
Rob

Posted by Ian on August 13, 2001 4:59 AM

use

=SUMIF(A1:A7,1001,B1:B7)

or you could put a cell to the left of the sumif

=SUMIF(A1:A7,A8,B1:B7)

where the value 1001 is typed in A8

Good luck

Ian

Posted by Rob Field on August 13, 2001 5:47 AM

Thanks Ian

You're a top man - worked first time with little change

Thanks again

Rgds

Rob