title: Searching within google spreadsheet
body: <p>I need to search multiple spreadsheets like this for certain words like "#work" and "#hobbies" and add up the numbers on the adjacent column.</p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1XRI6PtrTTIPK5wGj6cWaa9puWBjwdMimuxLnIp1sGFE/edit?usp=sharing" rel="nofollow">https://docs.google.com/spreadsheets/d/1XRI6PtrTTIPK5wGj6cWaa9puWBjwdMimuxLnIp1sGFE/edit?usp=sharing</a></p>
  
  <p>In this sheet, I need to add up the values in "Sheet 2" and "Sheet 3", for the cells in column B adjacent to the words "#work" and "#hobbies". After I add them up, I want to put the total for "#work" and "#hobbies" in the cell adjacent to "#work" and "#hobbies" in "Sheet 1".</p>
  
  <p>Essentially I want to assign "Sheet 1!B1"="Sheet 2!B1"+"Sheet 3!B3"</p>
  
  <p>and</p>
  
  <p>"Sheet 1!B4"="Sheet 2!B4"+"Sheet 3!B9"</p>
  
  <p>Since I dont know the location of these words "#work" or "#hobbies" apriori, I need to search in column A, and find out the values and then add them up.</p>
  
  <p>What code or function will help me evaluate this and do this job?</p>