title: Excel - Using COUNTIF/COUNTIFS across multiple sheets/same column
body: <p>I am trying to "COUNT" the number of a certain object in column I (in this instance) across multiple sheets. That value in column I is the result of a formula (if it matters). So far I have:</p>
  
  <p><code>=COUNTIF('Page M904'!I:I,A13)+COUNTIF('Page M905'!I:I,A13)+COUNTIF('Page M906'!I:I,A13)</code></p>
  
  <p>which works, but I am going to have 20 something pages to scan through. I would like to avoid having a page long formula.</p>
  
  <p>I have tried</p>
  
  <p><code>=COUNTIFS('Page M904:Page M906'!I:I,A13)</code> and 
  <code>=COUNTIF('Page M904:Page M906'!I:I,A13)</code></p>
  
  <p>but that results in a <code>#VALUE</code>.</p>
  
  <p>And I think</p>
  
  <p><code>=COUNTIFS('Page M904'!I:I,A14,'Page M905'!I:I,A14,'Page M906'!I:I,A14)</code></p>
  
  <p>is a misapplication of the <code>COUNTIFS</code> because I get <code>0</code> when it should be 35.</p>
  
  <p>I am trying to avoid using VBA for this application. But if has to be, then it has to be :) Thanks in advance for your time and help.</p>