title: Sumif between two dates over two columns
body: <p>I would like to sum a column between two dates, however the dates are in separate columns. </p>
  
  <p>I want the sum total between the following dates 01-01-2014 (cell E1) and 31-03-2014 (cell F1). </p>
  
  <p>If you look at cell C6 the date is lower than the first range and is being included as you would expect. </p>
  
  <p>The current formula looks at the two columns individually i.e. is Start date (column B) above E1 and then is End date (column C) below F1. </p>
  
  <p>I need a formula that takes into account both dates i.e if start date is above E1 and below F1 then sum the Price column. </p>
  
  <p>The date at C6 is something I would like to avoid, even though it is below cell F1 I still want it to be above cell E1.</p>
  
  <p>Is anyone able to lend some assistance on how I could do this?<img src="https://i.stack.imgur.com/pGC70.png" alt="enter image description here"></p>