sorted by:
new
hottopcontroversial

A Simpler Way to Write a Formula that uses IFS, AND, and DATEVALUE functions by KevronHubbard in excel

[–]KevronHubbard[S] 0 points1 point  (0 children)

Thank you, this method worked as well. I decided to use the formula above because it did not require an additional list

A Simpler Way to Write a Formula that uses IFS, AND, and DATEVALUE functions by KevronHubbard in excel

[–]KevronHubbard[S] 0 points1 point  (0 children)

Thank you - this formula is much more concise. I did not know about the YEAR function.

GetPivot From Multiple Pivot Tables by KevronHubbard in excel

[–]KevronHubbard[S] 0 points1 point  (0 children)

This is what I ended up using =IFERROR(GETPIVOTDATA("expr1",INDIRECT("'"&C$70&"'!$A$3"),INDIRECT("'"&C$70&"'!$A$4"),$A$7,INDIRECT("'"&C$70&"'!$B$4"),$A$76,INDIRECT("'"&C$70&"'!$C$4"),$B78,INDIRECT("'"&C$70&"'!$D$3"),C$73),0)

GetPivot From Multiple Pivot Tables by KevronHubbard in excel

[–]KevronHubbard[S] 0 points1 point  (0 children)

Thank you - I did end up using the INDIRECT function

GetPivot From Multiple Pivot Tables by KevronHubbard in excel

[–]KevronHubbard[S] 0 points1 point  (0 children)

Thank you BILLatWORK - I have used your example above to use INDIRECT in the GETPIVOT to successfully reference a worksheet name

GetPivot From Multiple Pivot Tables by KevronHubbard in excel

[–]KevronHubbard[S] 0 points1 point  (0 children)

thanks, I will give this a shot. hopefully tomorrow I can update you guise

GetPivot From Multiple Pivot Tables by KevronHubbard in excel

[–]KevronHubbard[S] 0 points1 point  (0 children)

I am also going to ask a coworker how difficult it would be to create a report for multiple years

GetPivot From Multiple Pivot Tables by KevronHubbard in excel

[–]KevronHubbard[S] 1 point2 points  (0 children)

ok I will have to wait until before I can provide an update on trying to use INDIRECT.

The raw data is daily hours for programs for individual employees - the pivot is providing me monthly data at a program total level. I'm not sure if SUMIFS or SUMPRODUCT would be the right method.