Microsoft Excel help.?

Question

In a spreadsheet I have a column that contain either Y for yes or N for no.

What formula can I use to count how many Y's or N's are in the column?

Please give an example.

Answer 1

you would use the countif() function

open up a new blank test sheet:

- in cells A1 down to A9 type a random Y or N in each cell

- then in an empty cell copy&paste this formula

=COUNTIF(A1:A9,"Y")

and that will count all the Y's you typed

-you can randomly change the Y's to N's to test how it works.

- just change the range and have a 2nd formula with "n" in your real sheet

enjoy