EXCEL SUMIFS formula of two columns removing dupliate entries
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
Microsoft OfficeMicrosoft ExcelMicrosoft Applications