Formula that will adjust when I filter the spreadsheet

I have this formula to calculate the percentage of times "yes" is in a cell but don't know hot to change the formula so that it will re-calculate the percentage when I filter the spreadsheet.  This g...