title: Sumif Dates are equal or greater with exception
body: <p>Hello I am working with a formula that adds a range of cells after comparing dates. For example range A1:A5 has random dates within the year 2017, range B1:B5 each contain the number 10, cell C3 contains the word "OFF". Range A6:A371 begins with 1/1/17 and ends with 12/31/17. I would like a formula that adds the 10 onwards beginning on the date mentioned in A1:A5 but not if it says "OFF" from that date onwards. The formula I have to add them is</p>
  
  <p>=SUMIF(A7,">="&amp;$A$1,$B$1)+SUMIF(A7,">="&amp;$A$2,$B$2)+SUMIF(A7,">="&amp;$A$3,$B$3)+SUMIF(A7,">="&amp;$A$4,$B$4)+SUMIF(A7,">="&amp;$A$5,$B$5)</p>
  
  <p>Is there a better formula and how can I have it not include the date that has "OFF" in column C? I hope I have explained the problem and goal well, if not please ask me to clarify further.</p>