title: How to Combine 2 Functions in 1 Cell on a Google Spreadsheet and have the results for the 2nd function appear in the notes for that cell
body: <p>Hi I'm trying to figure out a way to combine Multiple Queries into the same cell on a Google Spreadsheet.</p>
  
  <p>Here is the setup:</p>
  
  <p>I can use
  =COUNTIF('Form Responses 1'!$BA$2:$BA$201, "Boots")</p>
  
  <p>to check sheet1 to see if "Boots" is in multiple cells in Column BA.  Then have it return the count in  cell A1 on sheet2.</p>
  
  <p>I can use
  =QUERY('Form Responses 1'!A2:BS, ("Select B, C where(BA='Boots')"))
  In a different cell on sheet2 and it will fill 2 columns and 3 rows with the results of the data from columns B and C in sheet1 as it relates to the Query results.</p>
  
  <p>But I can't figure out how to combine both</p>
  
  <p><code>=COUNTIF('Form Responses 1'!$BA$2:$BA$201, "Boots")</code></p>
  
  <p>&amp;</p>
  
  <p><code>=QUERY('Form Responses 1'!A2:BS, ("Select B, C where(BA='Boots')"))</code></p>
  
  <p>Into the same cell where the <strong>=COUNTIF shows in the Cell</strong> and the <strong>=QUERY results appear in the Notes for the Cell</strong>.</p>
  
  <p>Lets say columns B and C are Names and Ages of people and column BA is what they want to buy.</p>
  
  <p>The end result would be to show on sheet 2, in a single cell, both how many people want Boots and in the notes for that cell show a list of their names and ages.</p>