is there a way to combine subtotal and if then commands?

[bigdan]

I want to look at a filtered list and see how many items in col A are a Yes or a No.

I know to look at the total items in the filtered list I'd write =subtotal(2,A1:A100). But how do I separate the two values?

 

[Fluff]

Have a look here
https://exceljet.net/formula/count-visible-rows-only-with-criteria