Col 1 Col 2
a 1
b 1
c 1
a 1
b 1
a 1
c 1
d 1

I would like a function that will search Col1 for a Value and then sum the
values in Col 2 that have the same value in Col1

in the above example

the sum of a is 3
the sum of b is 2
the sum of c is 2
the sum of d is 1

Can there a function or functions that can do this in excel??

--
Message posted via http://www.officekb.com