title: Conditional sumproduct formula, incorporates: an excluded variable, offset/match lookup
body: <p>I need to calculate a weighted average rental rate, conditional on a few factors.</p>
  
  <p><a href="http://i.imgur.com/d8zDxlq.jpg" rel="nofollow">Link to my example</a></p>
  
  <p>I need the calculation to include all properties, but able to adjust out the Subject Property's values...</p>
  
  <p>I can't figure out how to have the sumproduct array <code>[=sumproduct(rates*units)/sum of units]</code> exclude the Subject Property's values.</p>
  
  <p>I'm pretty new to Stack - is there a better way to post example files?</p>