Sorry for poor title wording.
I am keeping track of quiz questions in a Google Spreadsheet. In order to generate question statistics I also keep track of some metadata about each theme in a different sheet. Finally, I want to show theme metadata statistics grouped by each quiz in a different sheet. All data is manually entered, except for the numbers which I want to be generated from a formula. Consider the following:
Sheet name: "Quiz 1"
|Super Mario||What is Mario's occupation?||Plumber|
|Call of Duty||What is Soap's real name?||John MacTavish|
|Tunic||What animal is the player?||A fox|
Sheet name: "Themes"
|Call of Duty||Well-known|
Sheet name: "Stats"
What is a formula/function I can use to calculate the numbers in the stats sheet?
Edit: Alternatively, would it be easier to group/structure the data differently?