title: Google Spreadsheet: SUMIFS for same Column
body: <p>I've got a problem in Google Spreadsheets:</p>
  
  <p>I don't know why, but for Google there is a problem to use the <code>SUMIFS</code> formula.</p>
  
  <p>When I try to use the <code>SUMIFS</code> formula for different criteria, for the <strong>same</strong> column, the output is always zero <code>0</code>.</p>
  
  <p>I tried aleady other things, but anyways it doesn't work.
  Here are my examples:</p>
  
  <ul>
  <li><p>Example 1</p>
  
  <pre><code>=SUMMIFS('Sheet1'!G1:G100;'Sheet1'!C1:C100;"Criteria1";'Sheet1!C1:C100;"Criteria2";'Sheet1'!D1:D100;"Criteria3")   
  </code></pre></li>
  <li><p>Example 2</p>
  
  <pre><code>=SUMMIFS('Sheet1'!G1:G100;'Sheet1'!C1:C100;{"Criteria1" ;"Criteria2"};'Sheet1'!D1:D100;"Criteria3")  
  </code></pre></li>
  <li><p>Example 3</p>
  
  <pre><code>=SUMMIFS('Sheet1'!G1:G100;'Sheet1'!C1:C100;"*Criteria1"&amp;"Criteria2";Sheet1'!D1:D100;"Criteria3")  
  </code></pre></li>
  </ul>
  
  <p>Non of these work. I dont know what I should do. Anyone has an idea?
  Thanks in Advance</p>