title: Sumif with a moving sumrange
body: <p>I have data, in corresponding columns right next to each other like : total in column n and hours in column o, I need a formula that changes my sumrange in my sumif formula.</p>
  
  <p>how to change the referring column for the sum range in a sum if formula based on the column name being selected from a drop down list?</p>