title: Google Sheets - Create formulas & data in Sheet 2 based on Data from Sheet 1
body: <p>I have a Google Sheets file with a wine cellar with several categories and info in Sheet 1.
  I'd like to create a second sheet that uses data from sheet 1 to show statistics about the cellar.</p>
  <p>The formula's I've got worked out and I can test by creating them in Sheet 1.</p>
  <p>For instance, &quot;=UNIQUE(E3:E110)&quot; in Cell A113 gives me a list of all the countries (column E lists countries) and &quot;=COUNTIF(E3:E110, A113)&quot; gives me the amount of wines I have of that country.</p>
  <p>Now I'd like to put this info in Sheet 2 but I am not able to reference the data from Sheet 1. I do know how to do it for a single cell (<a href="https://support.google.com/docs/answer/75943?hl=en&amp;co=GENIE.Platform%3DDesktop" rel="nofollow noreferrer">https://support.google.com/docs/answer/75943?hl=en&amp;co=GENIE.Platform%3DDesktop</a>) but haven't been able to create formulas with that.</p>
  <p>Can you help?</p>