You're welcome.

Once you get used to using them, Pivot Tables are wonderful tools. I used to spend a lot of time using Advanced Filters to extract lists and then using COUNTIFS and SUMIFS, etc., to analyse data. Pivot Tables take out all the pain.

Regards, TMS