I am new to Excel.  I have a project I am working on in which  I have a
column with a value from 1 to 5.  Each number (and in some columns letters)
represents a different answer.  Is there a way to add the total number of
each value? For instance I have over 2000 rows with data.  In column "N", an
answer can be either 1,2,3,4 or 5. How would I figure out how many answers
are "1", how many are "2" an so on. Likewise there is a column with a yes/no
answer. How can I see the total number of Yes's and how many No's there are?
I appreciate any help.