Create a new table that sums all the LeaveTypes

[stallare]

Hello all,
I've been searching the forum for some guidance but can't find exactly what is stumping me... any ideas?

I have a pivot table containing names and values, from that I want to sum together the total based upon both the name and a string value.
Here is an example:

Pivot1
LeaveType Matt Mark Luke John
sick 1
sick 3
annual 3
public 1
public 1
public 1
sick 2

I want to create a new table that sums all the LeaveTypes for the staff but it needs to be dynamic.

I have tried lots of combinations, the closest I get is:
=SUMIF(Pivot!A2:A1117,"sick",OFFSET(Pivot!A2,1,(MATCH(B5,Pivot!$A$2:$BA$2,0))):OFFSET(Pivot!A2,1117,(MATCH(B5,Pivot!$A$2:$BA$2,0))))
(where B5 = "Matt")

Any suggestions would be greatly appreciated before I pull my hair out!!!

Thanks

[Pepe Le Mokko]

Hi and welcome
your question is not very clear. At first glance you can do all this with the existing Pivot Table?
Perhaps post a sheet with your data and what you need?