title: Excel: How to refer to entire column in a formula by column title?
body: <p>I want to write a formula like <code>=SUM(tab2!A:A)</code> but instead use the column title of A which is say "count". How can I modify this to look more like: <code>=SUM(tab2!"count")</code>?</p>
  
  <p>The reason I want to do this is because I copy and paste a spreadsheet from another source in tab2 and the column referring to "count" may be in a different column. <strong>I want the formula to give me the correct calculation as soon as I paste the new spreadsheet by automatically finding the column to sum up by title name.</strong></p>
  
  <p>I must be missing something because this seems like a very basic question and I can't find the answer anywhere...</p>
  
  <p>Thanks for your help! </p>