From Column select Values to sum

[Fredriksson via OfficeKB.com]

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??

 

[Peo Sjoblom]

Select Column1 (header and range), do data>filter>advanced filter (don't
filter column 2 just 1), select copy to another location and unique records
only, that will give you a

header
a
b
c
d


now in the adjacent cell to the right of the cell with a, assume you copied
it to h1 then a would be in H2, so in I2 put

=SUMIF($A$2:$A$100,H2,$B$2:$B$100)



where A2:A100 is column 1 and B2:B100 is column 2

copy down as long as needed

 

[Fredriksson via OfficeKB.com]

Thanks

Select Column1 (header and range), do data>filter>advanced filter (don't
filter column 2 just 1), select copy to another location and unique records
only, that will give you a

header
a
b
c
d

now in the adjacent cell to the right of the cell with a, assume you copied
it to h1 then a would be in H2, so in I2 put

=SUMIF($A$2:$A$100,H2,$B$2:$B$100)

where A2:A100 is column 1 and B2:B100 is column 2

copy down as long as needed

Col 1 Col 2
a 1

[quoted text clipped - 17 lines]

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