D
Dr.Boo
Hi, I'm new to this forum and I'm having a problem with excel which
sounds very simple, yet I can't solve it.
Imagine this: I'm holding a survey in which I ask people if they smoke.
These are the results I see in Excel:
Person1: Yes
Person2: Yes
Person3: No
Person4: Yes
Person5: Yes
Person6: No
Person7: No
Person8: Yes
Where Person1, Person2, Person3 etc are in cells A1, A2, A3, etc and
the answers are each in a cell B1, B2, B3, etc. So basically, the cells
in column A contain the persons, and the cells in column B contain Yes
or No.
Now I want to know how many percent of the total amount of replies is
Yes, and how many is No. So if lets say 10 persons replied, from which
7 replied Yes, and 3 replied No, we would have 70% of Yes and 30% of
no, except that in reality, my survey has more possible replies, and
way more people having replied to it...
Anyone can help me? I need to calculate these percentages, and might I
also add I'd need to know it asap
I thank anyone who can help me in advance.
sounds very simple, yet I can't solve it.
Imagine this: I'm holding a survey in which I ask people if they smoke.
These are the results I see in Excel:
Person1: Yes
Person2: Yes
Person3: No
Person4: Yes
Person5: Yes
Person6: No
Person7: No
Person8: Yes
Where Person1, Person2, Person3 etc are in cells A1, A2, A3, etc and
the answers are each in a cell B1, B2, B3, etc. So basically, the cells
in column A contain the persons, and the cells in column B contain Yes
or No.
Now I want to know how many percent of the total amount of replies is
Yes, and how many is No. So if lets say 10 persons replied, from which
7 replied Yes, and 3 replied No, we would have 70% of Yes and 30% of
no, except that in reality, my survey has more possible replies, and
way more people having replied to it...
Anyone can help me? I need to calculate these percentages, and might I
also add I'd need to know it asap
I thank anyone who can help me in advance.