I have a pivot table that is showing hours people worked in 3 months (april may june). From left to right I want to sum up all the hours of people worked (sounds simple). But I want to calculate the sum within the pivot table (in column E) and not with for example me manually typing =sum(B5:D5) outside the pivot table. Why?

1. if I do "=sum..." (outside my pivot) as you see in my F column, then as I bring in more names its going to overwrite my formula. I am only filtering on 3 people right now and will want to bring in more. I will have to manually redo my sum formulas all over. I want where I can add/remove as many people as I want and the sum of all the months show automatically without me having to do it each time I add/remove a person.

2. I also want to make a pivot chart based on the sum of column E once I figure out my first question above. I currently (not showing in the pic) have manually entered in my sums (with SUM) but as I filter my pivot (for other data as needed) it no longer sees my reference cells and messes up. Which is why I want me SUM data to show in the pivot.

thank you


pivot.PNG