title: Combine two cells in sumproduct
body: <p>I have below table</p>
  
  <pre><code> ID      NEW                   ASSIGN
   123                       6/18/2015 15:48
   124    6/18/2015 11:13 
   125                       6/18/2015 9:22
   126                       6/17/2015 21:01
   127                       6/17/2015 20:30
   128                       6/16/2015 13:57
   129    6/15/2015 10:21 
   130                       6/15/2015 9:45
   131                       6/5/2015 8:26
   132    6/4/2015 11:02  
   133                       6/3/2015 16:01
   134                       6/18/2015 1:41
   135                       6/16/2015 3:37
   136    5/18/2015 18:36 
   137                       6/16/2015 3:33
   138                       5/11/2015 15:27
  </code></pre>
  
  <p>In cell E1:F1</p>
  
  <pre><code> Aging  =SUMPRODUCT(--(A2:A17&gt;128),--(A2:A17&lt;136),
  
   --(NETWORKDAYS(C2:C17+0,TODAY()+0,0)&lt;=30))
  </code></pre>
  
  <p>which gives me 5 as result.</p>
  
  <p>Now, the requirement is to make use of NEW column value in place of blank cells in ASSIGN column.</p>
  
  <p>Copy-paste NEW column values to ASSIGN cell is not an option, I am stuck with this.</p>