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

Select Column1 (header and range), do datafilteradvanced 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



--
Regards,

Peo Sjoblom



"Fredriksson via OfficeKB.com" <u27002@uwe wrote in message
news:7206c5201a61b@uwe...
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

Thanks

Peo Sjoblom wrote:
Select Column1 (header and range), do datafilteradvanced 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??

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200705/1