Pivot/subtoal help

[fleece]

Hi all,

I'm trying to analyse a customer's bill and struggling to Summarise how many days each individual has made a call to the follwing zones.

please see sample spreadsheet attched.

I just want to know for example malkeet has roamed 11 days and he made calls to these zones based on the data i have. Not sure if pivot table is the best option or if i need a formula?


Thank you for your help in advance