COUNTIFS with sorts?

Dave...were you thinking this:?

=SUM(COUNTIFS(INDEX($Q$2:$S$12,,MATCH($A18,$Q$1:$S$1,0)),"*",C2:C12,{"P","EX"}))

I am able to get the right values using above, but when I go to filter on either column A (programs) or B (portfolio) I was wanting the C18:p20 to reflect the filtered values. The function above and my original function have the same problem. They don't reflect the filtered values...