Google COUNTIF / COUNTIFS Formula Tables Based on Multiple Criteria

I am looking for some experience with formulas. I have an original data source and should be able to sum it up in a separate sheet based on a number of different variables in both numeric and text formats. I've tried some COUNTIFS, INDEX and other formulas I've seen on this site, but it just doesn't work the way I need it.

Column headers:

Timestamp
HRBP (name)
Date
Area name
Team name
Enquiry Type
Enquiry Summary

      

        
        
        
      

    

Summary data I need: Total HRBP type queries by area between the specified date range , where I can enter HRBP, Area and dates in specific cells, and the "Query Type" number will be displayed below (and then I can create graphs / diagrams).

My logic would be something like:

COUNT [Enquiry Type] IF ([HRBP = 'x'] AND [AREA = 'y'] AND [Date >='z'] AND [DATE <= 'a'])

      

        
        
        
      

    

Can someone please help me get to my final goal? Or does anyone know of an app solution that could easily create this analysis - data is entered through a Google form on the front.