title: SUMPRODUCT: calculating multiple sheets
body: <p>Purpose:
  I have 13 tabs. Tab one consolidates data from other sheets using fairly simple formulas. I am attempting to create a formula that will provide a total sum from all 12 sheets by identifying which "team" the charge belongs to. The sheets look similar to the following:</p>
  
  <pre><code>Amount  Team
  $52.00  Team Bob
  $2.52   Team Gene
  </code></pre>
  
  <p>I will need the total for each "team" to be tallied on the beginning summary page. </p>
  
  <p>This is the formula I built. </p>
  
  <p><strong>=SUMPRODUCT(--('January 14'!H3:H31="Team Bob"),'January 14'!G3:G31)</strong>+('February 14'!H3:H31="Team Gene"),'February 14'!G3:<em>G31</em>)</p>
  
  <p>The first half works (in bold), but when I try to add the formula to pull from the next tab it highlights "G31" and does not make recommendations on how to repair. How do I add additional tabs so that I have the data from January added with all other months?</p>