Microsoft Excel adding up the number of YES's

Question

In my Microsoft Excel file, I have a column like this:

YES
NO
YES
YES
YES
NO
YES
YES

In a separate cell, using an equation or something, I want to count up the number of YESs in that column. How can I do this?

Answer 1

You can just use this:

=COUNTIF(A:A, "YES")

Answer 2

I don't think this really belongs on a programming forum.... But:

COUNTIF(, "YES")

should do it.