Filter

hi all i am new to this so please forgive any mistakes,
i have a couple of problems i want some help with.
first problem, in column h i have set a filter to show names of employees and in row g either the answer yes, or no,i have also set up a count to count the yeses this works a treat but if i filter the names then the number of visible yeses on the sheet (25) change to (12) but not the result of the formula it still shows 25 not 12 , how do i get it to count only the visible yeses ?.
and my second problem is can this be done with a chart as well IE only using the text visible?
i am using excel 2007

thanks for the formula i do not understand it but will give it a try

it works great thank you, will post a new prob in a min or so for you to solve i hope , again cheers.