title: Excel Dynamic operations for range
body: <p>I am preparing a test plan for a product , I want the summary report to be filled automatically when the test cases are updated.</p>
  
  <p>I want to "=countifs(Fromcell:Tocell) , i want to have this range based on a criteria. Example if my range is A1 to A100 , I don't want to hardcode instead i would like excel to take the start cell if it contains START in the cell and the end cell if it contains END in it. </p>
  
  <p>Thanks in advance.</p>