Hey, so i've been trying to figure this one out for a fair bit and have been really scratching my head.
I've got a workbook containing multiple sheets of reporting, each one follows the same format, something like this
Each page can have one of several different category codes but may have multiple pages that use the same category
What i'm trying to do is find a way to check each page and create a sum of each individual's scores sorted by category code to create something like this
The category codes are all in cell I1 of each page, so I know i'm going to need to somehow do a conditional sum across pages and matching usernames but how exactly to achieve this, i'm somewhat at a loss.
I've got a workbook containing multiple sheets of reporting, each one follows the same format, something like this
| USERNAME | NONRELEVANT HEADER | NONRELEVANT HEADER | SECTION SCORE | SCORE CATEGORY CODE | Cat1 | ||
| Exampleuser 1 | Nonrelevant Data | Nonrelevant Data | 1 | ||||
| Exampleuser 2 | Nonrelevant Data | Nonrelevant Data | 1 | ||||
| Exampleuser 3 | Nonrelevant Data | Nonrelevant Data | 2 | ||||
Each page can have one of several different category codes but may have multiple pages that use the same category
What i'm trying to do is find a way to check each page and create a sum of each individual's scores sorted by category code to create something like this
| USERNAME | Cat1 total | Cat2 total | Cat3 Total | Overall Total | |
| Exampleuser 1 | 1 | 3 | 4 | ||
| Exampleuser 2 | 2 | 2 | 4 | ||
| Exampleuser 3 | 1 | 1 | 1 | 3 |
The category codes are all in cell I1 of each page, so I know i'm going to need to somehow do a conditional sum across pages and matching usernames but how exactly to achieve this, i'm somewhat at a loss.
