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