How to use countif with subtotal

Hi,

I am trying to count number of lines by department over 30 days old.
Countif function works =COUNTIFS(C:C, "First Ops",D:D, ">29")

However when I filter this by owner, eg. filter for "Dave" and "Brian", need the countif value to change also.

Can anyone help me out

Thanks

If you want conditional counting applied only to rows which pass through filters, so are visible, you need to add a column to your table. If your complete data were in A1:P1000 with column labels in row 1, and if col A would never be blank, so COUNTA(A2:A1000) = 999, add formulas.

Q2: =SUBTOTAL(103,A2)

Fill Q2 down into Q3:Q1000. The col Q formulas will return 1 when the row passes through the filter (visible) or 0 when it doesn't (hidden). Then use COUNTIFS formulas like

=COUNTIFS(C$2:C$1000,"First Ops",D$2:D$1000,">29",Q$2:Q$1000,1)

You're a hero this works like a dream