You could try Excel's database functions such as DCOUNT() and DSUM()
These allow you to setup various criteria (like filters) for a database and each one will return the result from your database, so different 'filters' can be applied and each one returns a value.
Changing one set of criteria will not erase the value returned by another set of criteria.
Here is an example:
Put this data in cells B2 to E11
B C D E
2 Template Type Department Number
3 AMD-001 Standard Sales 2
4 AMD-002 Ad-hoc Sales 1
5 AMD-003 Standard Maintenance 4
6 AMD-001 External Small systems 2
7 AMD-002 Standard Main assembly 5
8 AMD-003 Standard Sales 1
9 AMD-001 Standard Sales 3
10 AMD-002 Ad-hoc Small systems 5
11 AMD-003 External Maintenance 6
The next two blocks are criteria for columns in the database - just like filters, and the Total column contains the result, in this case the sum of values in the Number column, but it could be a count of the number of rows that match the criteria.
G H I J
2 Template Type Department Total
3 AMD-003 Standard Sales 1
5 Template Type Department Total
6 AMD-001 Standard Sales 5
If you add drop downs to cells
G3, H3, I3 and
G6, H6 and I6
you can quickly filter the data and see the results in the final column.
The totals in J3 and J6 are independent, and you can create as many of these result blocks as you want.
If a value under a column header is left blank, that column won't be filtered.
The formula in cell J3 is:
The formula in cell J6 is:
Change DSUM in J6 to DCOUNT and you get 2, i.e., two records match your criteria.
Hope this is of interest.