title: Using importrange with Sumifs in Google Sheets
body: <p>I am trying to import some data from a very large sheet into another sheet using the sumif function that contains text and dates</p>
  <p>The sumif is as follows:</p>
  <p><code>=SUMIFS(H2:H, D2:D, &quot;United States of America&quot;, F2:F, &quot;&gt;01/01/2021&quot;, F2:F, &quot;&lt;01/01/2022&quot;)</code></p>
  <p>This works and returns the correct number</p>
  <p>However when I try to combines this with an importrange function it all falls apart</p>
  <p>All help greatly accepted</p>