jb
Member
Dear Helpers,
I have an excel sheet with students data like roll number, name and the answers they have given in quiz. Sample file: A2 to E5. c2, d2 and e2 are correct answers of Q1, 2 and 3.
I want to calculate total marks obtained by each student.
For that i have created table in H3 to J5 where I have calculated marks of individual question and then applied sum formula in k column.
Is there any single formula with which this calculation can be done directly without creating extra table?
Please also help me to calculate quiz marks if weightage of each question is different.
Sample file attached
I have an excel sheet with students data like roll number, name and the answers they have given in quiz. Sample file: A2 to E5. c2, d2 and e2 are correct answers of Q1, 2 and 3.
I want to calculate total marks obtained by each student.
For that i have created table in H3 to J5 where I have calculated marks of individual question and then applied sum formula in k column.
Is there any single formula with which this calculation can be done directly without creating extra table?
Please also help me to calculate quiz marks if weightage of each question is different.
Sample file attached
Attachments
Last edited: