title: Using a Dynamic Named Range inside a Sum Formula
body: <pre><code>=SUM(IF(('Old Data'!$A$2:$A$10000=Tracking!A9)*('Old Data'!$B$2:$B$10000=$E$7)*('Old Data'!$D$2:$D$10000&gt;$B$5)*('Old Data'!$D$2:$D$10000&lt;$C$5),IF('Old Data'!$E$2:$E$10000-'Old Data'!$D$2:$D$10000&lt;"4:00"+0,0.5,NETWORKDAYS('Old Data'!$D$2:$D$10000+0,'Old Data'!$E$2:$E$10000+0))))
  </code></pre>
  
  <p>is my current code.  I created a defined name Total</p>
  
  <p>Total = <code>=COUNTA('Old Data'!$C:$C)</code></p>
  
  <p>Everywhere that I have 10,000 I'd like to return the value of Total. I've tried simply replacing 10000 with Total, tryed using the + built in formula creator. I can't figure how to insert the value into my formula.</p>
  
  <p>Any Ideas?</p>