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