title: Insert alternating formulas into the same column
body: <p>Is it possible to use vba to insert 2 different formulas into the <strong>same</strong> column? I want the formulas to alternate. I'm trying to do Sumif's but the sum range keeps changing after every second line, so I need to be able to insert 2 different formulas.  </p>
  
  <p>So to try to explain this further - Say in Cell A1 I want to use a sumif and the sum range is column K, but then A2 has to sum column L, and then A3 has to go back to column K and so on. </p>
  
  <p>I tried to use using a vlookup , but there is no unique identifier. </p>
  
  <p>Is what I'm trying to achieve even possible?</p>