OpenOffice and how to count Yes's in a column ( or any string )

Click on Sum and use something like this

=COUNTIF(A2:A100000;"=yes")