If you have a column with different values within and would like to find out how many of a particular one there are you can use a conditional function called Countif.
This does what is says on the box, it counts if the cell meets a particular condition. So if you have a column with text in it, say Y or N you can count how many cells have Y in them.
If the values to count are in column B (cells B2 to B20) then the function will look like this:
= Countif (B2:B20, “Y”)
Only use quotations “” around text, numbers are types in without. There are exceptions to this. If Excel thinks the numbers are text then you need the quote. To make it easy, always start without quotations and if Excel does not count the number then add quotes around it.
Katherine Davison
Business Software Training Consultant