title: Excel Indirect with Count
body: <p>I have a workbook with different sheets for each month. I made another sheet where I put the months in A1 down.
  I wanted to use Counta (for A:A in the months' sheets) and indirect together but I am getting the result "1" with my formula.</p>
  
  <p>Please help:</p>
  
  <p>=COUNTA(INDIRECT(SheetNames!A1&amp;"!A:A"))</p>
  
  <p>I would also eventually like to do the same for countif. If you can please explain what I missed that will help me.</p>
  
  <p>Thanks!</p>