Hope you can help
Ive been trying to use SUMIF, SUM PRODUCT with FREQUENCY and MATCH to sum the quantities in stock locations but ignoring duplicate entries
I have column A and Column B - column A has the stock location which can be repeated several times with the unique stock quantity against the location in Column B
Ive tried creating a formula to sum the quantities in Column B but only for each unique location so for example, if in column A Stock Location PB12345 is repeated 6 times and has a quantiity of 500 - when the SUMIF runs through the the two columns, it only includes the sum of 500 from PB12345 once and not include the six times its repeated
Ive attached a sample file and the desired result in cell F1 - the formula im using shows how many times its repeated but not the sum ?
If you could help I would be very grateful