title: Ignore non-numeric values in sumproduct formula in excel
body: <p>I tried to use sumproduct formula, but it doesn't ignore non numeric (text) values. </p>
  
  <p>Tried double unary. But nothing works</p>
  
  <pre><code>=SUMPRODUCT((A2:A8="TX")*B2:B8)
  =SUMPRODUCT(--(A2:A8="TX")*B2:B8)
  =SUMPRODUCT((A2:A8="TX")*--B2:B8)
  =SUMPRODUCT(--(A2:A8="TX")*--B2:B8)
  
  State   Sales
  UT  75
  CO  100
  TX  125
  CO  125
  TX  150
  TX  a
  CO  50
  </code></pre>
  
  <p>I know sumif can do, but im trying to achieve the same from Sumproduct, coz i need to apply it in larger frame</p>