title: Auto increment row number in excel sheet
body: <p>I have the following formula written in the cell B5</p>
  
  <pre><code>=SUMPRODUCT(--(COLORINDEXOFRANGE(Data!D10:HO10,FALSE,1)=COLORINDEXOFONECELL(Data!$F$3,FALSE,1)))
  </code></pre>
  
  <p>When i drag down from B5 to the next row, the cells in the formula change to <code>COLORINDEXOFRANGE(Data!D11:HO11,FALSE,1)</code> </p>
  
  <p>But i want the column number to remain the same and want just the row number to change to, for example <code>COLORINDEXOFRANGE(Data!E10:HO10,FALSE,1)</code> for the cell C5 and <code>COLORINDEXOFRANGE(Data!F10:HO10,FALSE,1)</code> for cell D5 and so on.</p>
  
  <p>COLORINDEXOFRANGE is an inbuilt function that i found on the internet. </p>
  
  <p>Please help.  Thanks</p>