Look up to Duplicate cells and return the sum total of each unique duplicate cell

[dhome]

Good afternoon to everyone,

I hope your all getting used to the new normal while we try to counteract COVID19.

I have two sheets

Here is a small summary of my data set

Sheet 1 - My lookup is in column A 0054 and my formula is in column F - 137.70

Sheet 2 - is the table array with duplicate values Column A:B

I would like a formula to lookup and sum duplicate reference numbers so sheet A in this example ref 0054 would agree to the total of 497.70 and would pull that amount into the cell and not 137.70



Sheet 1

0054

497.7

08/09/2020

CLAIRE

137.7

CHECK

Sheet 2

0054	137.7	Sales Payment	Faststat Limited			497.7​	check
0054	360	Sales Payment	SKS			497.7​	check

Thank you for your help

 

[Fluff]

Probably best you start another thread.

 

[dhome]

Ok I will do and thank you for your help,

Is there any place I can add feedback

 

[Fluff]

All you need to do is post to say that it's working, which you've already done.

 

[dhome]

Thank you

 

[Fluff]

Glad to help & thanks for the feedback.

 

[dhome]

Thanks again.