title: Google Sheets COUNTIF / COUNTIFS formulas based on multiple criteria
body: <p>I'm looking for some expertise with formulas. I've got a raw data source and need to be able to summarise it in a separate sheet based on a number of different variables of both number and text formats. I've tried some COUNTIFS, INDEX and other formulas that I've seen published on this site, but it's just not working the way I need it to.</p>
  
  <p>The column headings are:</p>
  
  <pre><code>Timestamp
  HRBP (name)
  Date
  Area name
  Team name
  Enquiry Type
  Enquiry Summary
  </code></pre>
  
  <p>The summary data I need is:
  <strong>Total number of Enquiry Type by HRBP by Area between specified date range</strong>, where I can enter the value of HRBP, Area, and dates in defined cells, and the 'count' of Enquiry Type will be displayed below (and then I can create graphs/charts).</p>
  
  <p>My logic would be something along the lines of:</p>
  
  <pre><code>COUNT [Enquiry Type] IF ([HRBP = 'x'] AND [AREA = 'y'] AND [Date &gt;='z'] AND [DATE &lt;= 'a'])
  </code></pre>
  
  <p>Can someone please help get to my end goal? Or does anyone know of an App solution that could create this analysis easily enough - the data is entered via a Google Form at front end.</p>