Forum Discussion
Display Ratings from All Users
All the 5 Teachers have updated the ratings and shared their respective sheets.
Task is to collate the ratings of all the teachers and display together. Also average ratings of all the ratings received from Teachers.
How to accomplish this task in Excel?
kiranpoojari If you can copy all the teachers worksheets (or workbooks) into one worksheet, you could fairly easily summarise the score per student using SUMIF as demonstrated in the attached workbook.
However, if your real situation isn't just limited to three students and five teachers, and if you are not on a Mac, you might consider looking into Power Query.
2 Replies
kiranpoojari If you can copy all the teachers worksheets (or workbooks) into one worksheet, you could fairly easily summarise the score per student using SUMIF as demonstrated in the attached workbook.
However, if your real situation isn't just limited to three students and five teachers, and if you are not on a Mac, you might consider looking into Power Query.
In the picture I see three students and three columns for teachers, not five.
You send a picture, why?
Better said, why should I create a file with what you probably mean.
Why not make a file (without sensitive data) with what you mean exactly.
This could help you faster.
Thank you for your patience and understanding
Nikolino
I know that I know nothing (Socrates)
