title: INDIRECT FUNCTION doesn't work in Google Sheets
body: <p>I'm trying to sum a discontinuous range with SUM, COUNTIF and INDIRECT formulas. It works well in Excel, but when I upload my file in Google Drive and open it, the sum is different.</p>
  <p>This is my formula. When I mark with X the cells D3, F3 or H3, I get the sum.</p>
  <blockquote>
  <p>=SUM(COUNTIF(INDIRECT({&quot;D3&quot;,&quot;F3&quot;,&quot;H3&quot;},TRUE),&quot;X&quot;))</p>
  </blockquote>
  <p>The same formula in Google Sheets only get the sum of D3, if I modify F3 or H3, the result doesn't change</p>
  <p>Is there a way that you can function this formula in Google Sheets or get the sum of discontinuous cells?</p>
  <p>Thank you!</p>