Hi

I am trying to figure out how to combine the SUBTOTAL and COUNTIFS functions.

As you can see the COUNTIFS counts the “Y”in column A and “Unknown”in column D.

When I apply the sort feature the COUNTIFS function number remains the same , but the SUBTOAL function number alters based on the sort criteria.

Is my way possible to achieve.

I have attached a copy of the excel spreadsheet.