Forum Discussion
Solved
Display Ratings from All Users
The attached screenshot is a performance table of 3 Students. Column A consist names of Students. Row 1 consist different performance parameters. The spreadsheet was shared with 5 Teachers and asked t...
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.
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.