i have column E with downwards multiple entrys of wich some is repetetive in other words
e13 a
e14 b
e15 a
e16 c
e17 a
e18 b
e19 a
e20 c
e21 a
e22 b

and in g i have amounts thats corresponding/refering to E for example
g13 100
g14 101
g15 204
g16 20
g17 50
g18 10
g19 100
g20 101
g21 30
g22 47

i need in column L to only show

L13 a
L14 b
L15 c

and in column M i will need the sum of all the a's in M13 and sum of b's in M14 and sum of c's in M15 for example

M13 484
M14 158
M15 121

there will be on different sheets different amounts of rows so it could be on one sheet 23 unique items in column E and on another sheet 100 unique items

thank you!!!

can send sample of the workbook

Hi Phillip,

Am Thu, 18 Jun 2020 12:09:00 -0700 (PDT) schrieb Phillip Swanepoel:

i have column E with downwards multiple entrys of wich some is repetetive in other words
e13 a
e14 b
e15 a
e16 c
e17 a
e18 b
e19 a
e20 c
e21 a
e22 b

and in g i have amounts thats corresponding/refering to E for example
g13 100
g14 101
g15 204
g16 20
g17 50
g18 10
g19 100
g20 101
g21 30
g22 47

i need in column L to only show

L13 a
L14 b
L15 c

and in column M i will need the sum of all the a's in M13 and sum of b's in M14 and sum of c's in M15 for example

M13 484
M14 158
M15 121

in M13:
=SUMIF($D$13:$D$22,L13,$F$13:$F$22)
and copy down


Regards
Claus B.
--
Windows10
Office 2016

Hi again,

Am Thu, 18 Jun 2020 21:15:44 +0200 schrieb Claus Busch:

in M13:
=SUMIF($D$13:$D$22,L13,$F$13:$F$22)
and copy down

sorry, typo!
=SUMIF($D$13:$D$22,L13,$G$13:$G$22)


Regards
Claus B.
--
Windows10
Office 2016

Thank you Claus

just note that column L is empty. the data from E stil needs to be 'send' to L

I see you used D(should be E)

i have like the following now

first i will need to get L filled with all the unique values from E

then in M need to do a sum of all the uniques corresponding amounts


On Thursday, June 18, 2020 at 9:17:23 PM UTC+2, Claus Busch wrote:
Hi again,

Am Thu, 18 Jun 2020 21:15:44 +0200 schrieb Claus Busch:

in M13:
=SUMIF($D$13:$D$22,L13,$F$13:$F$22)
and copy down

sorry, typo!
=SUMIF($D$13:$D$22,L13,$G$13:$G$22)


Regards
Claus B.
--
Windows10
Office 2016