Mmm....you lost me a little bit there, but it SOUNDS like the function you're looking for is "countif". See the screen shot below.
The formula is visible in the formula bar up top, in this case, =CountIF(B1:B6,"yes") will count all instancesof the word "yes".
