title: Have one cell represent a cell range
body: <p>Excel 2003 Question:<br>
  I'd like to have one cell represent a range of cells. So that another formula can use it.</p>
  
  <p>Right now, I have an equation to sum the hours worked on a specific project. It looks for a project name, and then beside it, I have a column with how long i've spent on it. This is the formula  <code>=SUMIF(D1:D10,"project1",C1:C10)</code>  </p>
  
  <p>If you look at the first picture,<br>
  I want B10 to say the range of Duration (B23-B28)<br>
  I want C10 to say the range of Project (C23-C28)  </p>
  
  <p>Now look at the second picture, with the formula.<br>
  Instead of having the range manually, I just want it to look at B10, and C10 so I get the range once. This way, I only have to change the range in one spot instead of how ever many projects I have. </p>
  
  <p>I'm sorry if this is a messy problem. I'm not sure how to ask it, but I will be quickly answering comments if people aren't clear on what I'm trying to accomplish. </p>
  
  <p><img src="https://i.stack.imgur.com/35pav.png" alt="enter image description here"></p>
  
  <hr>
  
  <hr>
  
  <p><img src="https://i.stack.imgur.com/D1Nb6.png" alt="enter image description here"></p>