title: Importing data from a table using the IMPORTXML function in Google Sheets
body: <p>First of all, I'm completely incompetent and my hours-long attempts at trying to make this work have been fruitless. So, please, talk to me like I don't know anything about coding, which is true, by the way.</p>
  
  <p>Here it is:</p>
  
  <pre><code>&lt;tr&gt;
  &lt;td colspan="6" class="ar lt pb5"&gt;186,272&lt;/td&gt;
  &lt;/tr&gt;
  </code></pre>
  
  <p>What I'm trying to import to a Google Sheets cell is the "186,272" bit.</p>
  
  <p>The entire code can be found here: <a href="http://www.sportsclubstats.com/d/NHL/Western/Pacific/Edmontonlottery27D.xml" rel="nofollow">http://www.sportsclubstats.com/d/NHL/Western/Pacific/Edmontonlottery27D.xml</a> (the "186,272" part is at the very end).</p>
  
  <p>None of my attempts at pulling the right part of the table (or any part of it, really) through xpath_query have worked so far, and I'm 98% sure I'm doing something wrong.</p>
  
  <p>Please, enlighten me.</p>