G
Guest
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.
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.