Forum Discussion
Solved
Sum Pivot Table Results With Other Cells & Show Growth in Headcount in Another Pivot
I have raw data that I summarize in a Pivot Table. I then have a table-like area for inputs for new persons coming in (peach area for inputs and formulas for values). 1) I currently use a SUMIFS ...
In Q12:
=SUMIFS(Table1[[Amount ]:[Amount ]],Table1[[Department]:[Department]],$P12,Table1[[Month]:[Month]],Q$11)+SUMPRODUCT($Q$3:$AB$5,($N$3:$N$5=$P12)*($Q$2:$AB$2=Q$11))
Fill down, then to the right (or vice versa).
Note that the total in Q19 is now correct.
In Q12:
=SUMIFS(Table1[[Amount ]:[Amount ]],Table1[[Department]:[Department]],$P12,Table1[[Month]:[Month]],Q$11)+SUMPRODUCT($Q$3:$AB$5,($N$3:$N$5=$P12)*($Q$2:$AB$2=Q$11))
Fill down, then to the right (or vice versa).
Note that the total in Q19 is now correct.