title: Array Formula with lookup value
body: <p>I'm splitting my stock of apples and oranges across three customers.  Price is based on mode of transport.  I want to calculate revenue by customer.  I'm trying to avoid intermediate calculations in other cells and would like to describe the entire customer calculation with one formula.</p>
  
  <p>The array formula I'm using doesn't seem to honor the different modes in the calculations.</p>
  
  <p>The formula in B11 is at the bottom.</p>
  
  <p>Any suggestions? Thank you in advance.
  <img src="https://i.stack.imgur.com/caD6J.png" alt="enter image description here"></p>