title: Use data from two documents inside formula (not import data)
body: <p>I am transferring from MS Excel to Google Sheets. My Excel formula is:</p>
  
  <pre><code>=SUMIF(FIGURES!$C$7:$C$105,N7,FIGURES!$D$7:$D$105)
  </code></pre>
  
  <p>The <code>FIGURES</code> sheet is within the same MS Excel document.</p>
  
  <p>Now I have two separate Google Sheets documents:<br>
  1. active.gsheet<br>
  2. figures.gsheet  </p>
  
  <p>How do I link/refer data from another Google Sheets document (I am not importing data, but using data in the formula)?</p>
  
  <p>So if I am entering the formula inside of <code>active.gsheet</code>:</p>
  
  <pre><code>=SUMIF( [figures.gsheet]$C$7:$C$105,N7,[figures.gsheet]$D$7:$D$105)
  </code></pre>
  
  <p>Also not sure if the formula in Excel is the same structure as Google Sheets.</p>