title: Counting the number of times a phrase appears in a column
body: <p>I am working on a project at work and am very unfamiliar with excel vba. My boss has given me a worksheet with a column containing multiple student ID numbers and the rest of the columns are their answers to a survey. The survey was multiple choice and select all that apply. </p>
  
  <p>I need to figure out a way to find the number of times one of the questions from the multiple choice questions were chosen. 
  So for example if there are 10 students and there is a question with 2 answers and 5 people chose Yes and 5 chose No, I need it to ultimately tell me that 50% chose answer Yes and 50% chose answer No.</p>
  
  <p>For the non multiple choice questions such as select all of the AP classes you have taken in the past, I need to know the same thing. Because this is a question, some of the cells in that column are blank. </p>
  
  <p>I have been trying hard to find out a solution. So far I have tried to do a countIF on the number of times one of the answers appeared in a certain column (I cant search the whole worksheet because many of the questions have the same option of answers). My big problem with this is that I can't figure out how to write the range for the countif because I need the range to be the column number I declare it but the row needs to be the last row in the column with data. The range will not be the same every time because the amount of students who take the survey changes every time, so I woud need the range to be the first row of the column that I set it as, like A1 and then the last row in that column. </p>
  
  <p>Any help or resources on how to do this would be great, I have been searching all over the internet and reading about vba. </p>