Table Assistance

I have a spreadsheet schedule that can be sorted by department, bannermanger1, or bannermanger2.

I'm trying to populate a table that has rows listing manger1, manage2, etc. and column headers listing cyclea, cycleb etc. where a cycle represents a specific date range on the schedule. For example, cycle a refers to all the events happening on the schedule between 12/7 - 1/4.

I'd like to populate cell1 [ manager1, cyclea ] with the count of all instances of 'pst' for that manger during that specific date range.

The user needs to be able to sort department, bannermanger1, or bannermanger2 without affecting the data within the table.

This was our initial attempt, but it only allows the user to sort by department. If we sort by bannermanager1, the data in the table is no longer correct.

=COUNTIF(OFFSET('2013'!$A$17,$T60,W$58,1,1):OFFSET('2013'!$A$17,$U60,W$59,1,1),"PST")

Your assistance is greatly appreciated.

In the instance below cyclea and cycleb refers to three weeks on the calendar.

cyclea begins cycleb begins
manager1 PST PST
manager1 PST
manager1 PST PST
manager2 PST PST
manager2 PST

and here's the table to populate the PST counts :

cyclea cycleb
manager1
manager2

Thank you Richard. I suppose I need to work on wording. Newbie.

No experience with Data Advanced Filter, but I'll research it, as well as, the COUNTIFS approach.

The Endgame is a Chart which will adapt to the changes we make to the schedule.

---------- Post added at 02:13 PM ---------- Previous post was at 02:11 PM ----------

This is my base question : How many "PST's" does "manager1" have during "cyclea"?