title: Excel: Multiply arrays based off conditions
body: <p>This is giving the run around</p>
  
  <p><img src="https://i.stack.imgur.com/FOQZJ.jpg" alt="Example Below"></p>
  
  <p>Using the picture above as an example, how do I find the cost*days of all approved/unapproved line items?</p>
  
  <p>I played around with a few methods but they all came up short. I think sumproduct is the right path but I cant work additional conditions in the statement.</p>
  
  <p>Cheers</p>