title: Multiple Sumrange in SUMIFS excel
body: <p>I am trying to use SUMIFS in excel. I was thinking I can select the multiple cell for one sumrange criteria <code>(SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …))</code> in different column by pressing Ctrl+select but its not the case. When I am selecting like this, its adding comma and going to another criteria.  I can able to achieve this by adding multiple sumifs like <code>=sumifs() + sumifs ()</code> to achieve what I need. I wrote the working formula as</p>
  
  <pre><code>=SUMIFS('Daily Log Sheet'!E3:E63, 'Daily Log Sheet'!B3:B63, 'Monthly Record'!B4) + SUMIFS('Daily Log Sheet'!E74:E144, 'Daily Log Sheet'!B74:B144, 'Monthly Record'!B4)
  </code></pre>
  
  <p>Instead of using multiple sumifs statement, is there any way to select multiple cell in different column in one criteria. Like by adding <code>&amp;</code> operator in one criteria. I tried this but not working. </p>
  
  <p>Its taking a lot of time in writing multiple sumifs statement and I have many sheets to work on. There is any way to select multiple cell in one criteria. </p>