title: SUMIFS Formula that would check multiple columns
body: <p>I have an excel sheet and am attempting to incorporate a SUMIFS formula which would check one column for an condition then check another group of columns to see in the match a condition in order to sum all the values which are > 50000 in the group of columns then multiply those values by 0.084.
  My formula returns the #VALUE error. How can I achieve what i want?</p>
  
  <pre><code>A     B     C     D     E     F     G     H     I
  
  NO                    51000 52000 12000 10000 53000
  
  NO                    23000 48000 54000 55000 50000
  
  =SUMIFS(E10:I610,A10:A610,"No",E10:I610,"&gt;50000")
  </code></pre>
  
  <p>Help please...</p>