I have a spreadsheet with data using ODBC. On my spreadsheet, i have an identifier for each piece of data. I am trying to find a way i can sum the data that has the same identifier. I have attached a screenshot of what i am trying to do. See pic attached.
You will see on the picture, i have one worksheet with the data. On the 2nd worksheet, i want to do a sum vlookup to sum all of the "Prices" that are associated with the ID number 32. I don't know if sum vlookup exists, but this is just to give you an idea what i am trying to do. Thanks!!!