title: How to use SUMIF if criteria contains a ">" symbol?
body: <p>So I tried using the SUMIF formula as follows: </p>
  
  <pre><code>=SUMIF(A1:A10, "&gt;30D", B1:B10)
  </code></pre>
  
  <p>Within my criteria range, there are instances of '>30D' occurring as a value. For instance, my data would look like this:</p>
  
  <pre><code>A        B
  &gt;30D     200
  0-7D     100
  8-14D    200
  15D-29D  300
  &gt;30D     400
  </code></pre>
  
  <p>And I would like the formula to return 600. However, in the above formula, I'm getting the wrong values (double checked with a pivot table). I think this is because Excel is is interpreting ">30D" as an expression instead of a value. I've also tried referencing the cell itself with:</p>
  
  <pre><code>=SUMIF(A1:A10, $A$1, B1:B10)
  </code></pre>
  
  <p>This doesn't work either. Help would be much appreciated!</p>