Help on tracking days

Hello,

I am pretty new to spreadsheets and I hit a wall and google is not helping. Signed up to reddit just to ask this. Not sure how to explain this easily so there will be examples of what’s going on.

For the multiple projects I am tracking days taken using the formula the subtracts weekend and holidays for each phase

Project name. Phase. StartDate EndDate DaysTaken

————————————————————————————————————

Project 1 Phase A 10/31/25 11/11/25 8

Project 1 Phase B 11/12/25 12/4/25 15

Project 2 Phase A 10/31/25 11/11/25 8

Project 2 Phase B 11/12/25 12/4/25 15

I am putting this into a pivot table and averaging days taken for each phase from all the projects

Project name. PhaseA. Phase B

—————————————————

Project 1 8 15

Project 2 8 15

—————————————————

Average 8 15

Now I have a project that phase had to pause and wait for something to finish. So the data looks like this

Project name. Phase. StartDate EndDate DaysTaken

————————————————————————————————————

Project 3 Phase A 3/6/26 3/11/26 4

Project 3 Phase A 3/16/26 3/20/26. 5

So the pivot table is only taking the 4 not the 9

Project name. PhaseA. Phase B

—————————————————

Project 1 8 15

Project 2 8 15

Project 3 4

—————————————————

Average 7 15

I know if I change the plot table Values to Sum it will count the days as 9 but it will just add all the phase days together at the bottom. Is there a way to get the 9 to show up, but still get the total average at the bottom of the column?