Countif formula in excel table

[austin350s10]

Does anyone know how to use a countif formula in a table. I have a table in which I would like to total up all the occurrences of the word "yes" in one column and show it in the total row of that column. I have tried the following with no luck....any ideas what I'm doing wrong here?

=COUNTIF(SUBTOTAL(myTable,[myColumn]), "yes")
=COUNTIF([myColumn],"Yes")

 

[Weazel]

maybe ...?

=COUNTIF(Table1[MyColumn],"yes")

 

[austin350s10]

That kinda works but as soon as i apply a filter the count does not update. So if there were 6 "yes" before adding any filters and 1 "yes" after filter the total would still read 6 :-\

 

[Weazel]

have you tried adding a total row to your table under table tools....design?

 

[Marcelo Branco]

Maybe

=SUMPRODUCT(--SUBTOTAL(3,OFFSET([MyColumn],ROW([MyColumn])-MIN(ROW([MyColumn])),0,1)),--([MyColumn]="yes"))

M.