Creating a Summary Table based on Client Work and Resource Name
I need to get a summary report to show the resource name against both the client work and non-client work with total hours
I can get the totals using =SUMIF([Resource Name]1:[Resource
Name]17, [Field 1]#, [Hours - Client]1:[Hours - Client]17).
Can I use Index/Match to get my summary table, please advise?
Help Article Resources
Check out the Formula Handbook template!