Hi,
I have a column of data that I downloaded in cvs format from a database on the server. The members have answered yes or no to questions. Now for each member if they answer no, I dont want to do anything, If they answered yes, I want to add 1 to total sum of the column. The same member will repeatedly answer the questions and submit the form.
example
member 1 question 1 no question 2 yes question 3 no
member 2 question 1 yes question 2 no question 3 yes
member 1 question 1 yes question 1 no question 3 no
i want to total at the end of each colum question 1 for member 1 how many yes's question2 how many yes and question 3 how many yes's
and so on for each member.
Can anyone help?
and Thanks in advanced.
ShyAnn
I am using windows xp and micrsoft excel 2007
I have a column of data that I downloaded in cvs format from a database on the server. The members have answered yes or no to questions. Now for each member if they answer no, I dont want to do anything, If they answered yes, I want to add 1 to total sum of the column. The same member will repeatedly answer the questions and submit the form.
example
member 1 question 1 no question 2 yes question 3 no
member 2 question 1 yes question 2 no question 3 yes
member 1 question 1 yes question 1 no question 3 no
i want to total at the end of each colum question 1 for member 1 how many yes's question2 how many yes and question 3 how many yes's
and so on for each member.
Can anyone help?
and Thanks in advanced.
ShyAnn
I am using windows xp and micrsoft excel 2007
Last edited: