title: Parse Cells in Spreadsheet and get Geometric mean
body: <p>I have a google spreadsheet with entries like this:</p>
  
  <pre><code>| 102584 (46.93%) | 15561 (7.12%) | 15709 (7.19%) | 33358 (15.26%) 
  
  | 102522 (46.90%) | 15561 (7.12%) | 15709 (7.19%) | 33358 (15.26%) 
  </code></pre>
  
  <p>I want to grab the raw numbers beside the parentheses across a whole row and get the geometric mean for that row.  What I have right now is: </p>
  
  <pre><code>=geomean(arrayformula(index(split(G3:AQ3,"()"),0,1)))
  </code></pre>
  
  <p>So I try to <code>split</code> each cell by parentheses, <code>index</code> into the first element in the parsed array, operate on the whole range as an array with <code>arrayformulta</code> (otherwise it seems to add the raw number to the raw percent), and then get the <code>geomean</code>.  But this seems to only work on the first cell of the range.  If I tried operating on a column instead of a row, it seems to work, but I can't get the operations to work on a row for some reason.  Is there any advice?  </p>
  
  <p>Thanks</p>