Looking up values in multiple rows and totaling them together

Hi i am creating a bar inventory workbook and basically we have several locations on sheet 1 (bar left, bar right, coolers, wall for example). The same bottle of liqour can be in all locations, and what i want to do is create a formula that searches for the liqour name and gives me the total number of bottles in the store in sheet 2. Ive tried vlookup, hlookup, dsum, index/match and cant get it to work when the bottle is in multiple locations and adding them together. ive attached the sheet so you can get an idea of what im doing