title: Excel - autofill formula horizontally with cell number increment
body: <p>I have the following problem. I want to copy this formula <code>=SUMPRODUCT(--($C3:$Q3=C4:Q4))</code> ,which is in cell C13, to the adjacent cells (D13, E13, F13 etc.), but I want $C3:$Q3 to become $C4:$Q4. (basically <code>=SUMPRODUCT(--($C3:$Q3=C4:Q4))</code> ====> <code>=SUMPRODUCT(--($C4:$Q4=C4:Q4))</code> and so on). Dragging horizontally doesn't help, since autofill increments the rows and not the column number. </p>
  
  <p>I tried with OFFSET, but as far as I understand, it references the data and not the formulas. Any help would be appreciated. Thanks in advance. </p>