title: SUMIFS Is Blank OR Other Condition
body: <p>I am trying to sum the values in the B2:B4 range using the SUMIFS function if the dates in the C2:C4 range are either blank or after the date in cell C1.</p>
  <p><a href="https://i.stack.imgur.com/iOLoO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/iOLoO.png" alt="enter image description here" /></a></p>
  <p>I can add the values in B if cells in C2:C4 are either blank or if the dates are after C1, in separate formulae, but I cannot seem to combine those conditions into one formula with an OR condition.</p>
  <p>=SUMIFS(B2:B4,C2:C4,&quot;&quot;) + SUMIFS(B2:B4,C2:C4,&quot;&gt;&quot;&amp;C1)</p>
  <p>The formula that I am working on is actually much longer and complicated so I want to combine these conditions into one formula or condition inside a SUMIFS if possible.</p>
  <p>I have looked for hours but cannot seem to find what I am looking for. Solutions I have found thus far test for blank and a text value or if greater than 0, but not a comparison of non-text non-zero values such as dates. Does anyone know of the solution?</p>