title: How to calculate multiple occurances cumulatively in Excel?
body: <p>I have been playing around with this for a while without decent simple solution. Tried sum(if , match, and many others.</p>
  
  <p>So what I would like to accomplish is to have sheet that has Seller, Product and Volume like below, and then from that count how many products of type A one seller sold and so on. e.g.</p>
  
  <p>With an function it would pull out from A column unique names to E4:E6
  Then within an function it would pull out unique products from B column to F3:H3
  Then within an function it would calculate the table there between e.g so that Joe has sold total 4 apples and 5 bananas but no oranges</p>
  
  <p>Example Excel Sheet
  <a href="https://i.stack.imgur.com/xtgHG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xtgHG.png" alt="enter image description here"></a></p>
  
  <p>I first thought this would not be an complex, but I can't pull it off.</p>
  
  <p>This is my first question here ever, so hope it went even remotely right.</p>