In this chapter, you’ll learn about how to create a summary table of a student questionnaire in Microsoft Excel by using the functions. We will make use of COUNTIF, MATCH, INDIRECT and ROW functions.
Let’s take an example and understand how all these formulas will work:-
Column A contains student name, columns B to F contains the answer (Y/N) to 5 questions from each of the 5 students.
Each row includes the answers of one of the student. We want to create a summary table that will show a count of the questions answered Y and N for each student.
Follow below given steps:-
As you can see in the above image according to Student ID function will count the number of replies as per the categories.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.