SubTotal Count(2)

[realniceguy5000]

Hi,
I a formula in one of my cells so that when the data is filtered it will add up all the cells that have a yes in them. However I'm getting an error. If I use the countif formula it still adds all the cells with yes that are not in the filter selection.

So can someone help me with the correct formula to use when I filter my data?

Here is the problem

=subtotal(2,G5:G999,"Yes")

This works fine but wont work with the filter on it still counts all the "Yes".

=COUNTIF(G5:G5004,"Yes")

Thank You, Mike