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
Sheet 2
Thank you for your help
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