I am creating a spreadsheet for another survey's results. The survey is ten questions with letters A - F as the answers. Each letter corresponds to a different result in a different location on the spreadsheet. What I want to do is count the corresponding letter selected. For example, if the letter A is selected three times, the number 3 needs to appear in the results cell.
This is my setup: There are 6 people who will be taking this survey ( 5 plus me). Each person is a row and each question is a column. Column A row 2-6, and 8 are the survey takers. Columns B-K are answer locations for the ten questions. Rows 11 -16 are the total results of each letter. (i.e., row 11 is A, row 12 is B, etc. through F.
Thank you in advance.
This is my setup: There are 6 people who will be taking this survey ( 5 plus me). Each person is a row and each question is a column. Column A row 2-6, and 8 are the survey takers. Columns B-K are answer locations for the ten questions. Rows 11 -16 are the total results of each letter. (i.e., row 11 is A, row 12 is B, etc. through F.
Thank you in advance.