title: Sum multiple values in Index/Match function
body: <p>I am working on a distribution problem, analysing the volumes delivered to a set of stores (75 stores).</p>
  
  <p>I have an Excel file as follows:</p>
  
  <p><a href="https://i.stack.imgur.com/o9MFx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/o9MFx.png" alt="input"></a></p>
  
  <p>As you can see, each day does not contain the same stores, given that each store does not receive a delivery every day.</p>
  
  <p>I want to get a new table that has the code of the store in the columns, and the information about volume and miles in the rows. Furthermore, I want to sum the values of the volumes given that they belong to the same store. In this example this would look like this:</p>
  
  <p><a href="https://i.stack.imgur.com/kqxEQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kqxEQ.png" alt="output"></a></p>
  
  <p>As you can imagine, my spreadsheet is way bigger, having a total of 6500 rows and 800 columns. I was thinking about using the function combination of INDEX/MATCH, but I cannot see how to make it sum the multiple values for a given store in a given date.</p>