I am trying to aggregate a PivotTable's subrows, depending on that cell's associated grouping. Next to my Pivot I have a VLOOKUP helper column that gives the individual project's umbrella grouping, and another helper column to put the team name on each row. I believe using SUMIFs is the right way to go, but am relatively beginner with Excel formulas.
Here's what my sheet looks like:
(The grey part is the PivotTable).
I'd like to sum up the project groups in another table, so it turns out like this:
Would anyone be able to help with the correct formula to sum up the percentages for each project group?
Note: Did do it successfully on another Pivot in the workbook but there were only two criteria there. Looked like this:
=SUMIF($37:$37,$C$1,(INDEX($B$39:$B$75,MATCH($D$4,$B$39:$B$75,0))))
Here's what my sheet looks like:
(The grey part is the PivotTable).
I'd like to sum up the project groups in another table, so it turns out like this:
| Teams | Projects | January | February | March |
|---|---|---|---|---|
| Team Name A | Project Group A | 25% | 50% | 100% |
| Team Name A | Project Group B | 75% | 50% | 0% |
| Team Name B | Project Group A | 85% | 100% | 100% |
| Team B | Project Group B | 15% | 0% | 0% |
Would anyone be able to help with the correct formula to sum up the percentages for each project group?
Note: Did do it successfully on another Pivot in the workbook but there were only two criteria there. Looked like this:
=SUMIF($37:$37,$C$1,(INDEX($B$39:$B$75,MATCH($D$4,$B$39:$B$75,0))))
