CountIF Functions

[Alaska1]

I have countIF Functions in my spreadsheet for Customer, Industry and Level. My countif functions are on a worksheet and updating every time I add to the worksheet. Is there a way with countif to drill down to the Customers who fall under that Industry. I know I can use a pivot table to calculate total and drill down, but I do not want to remember to have to refresh every time the data updates. I am not the only ones using the report.