Formula to Count unique items based on multiple criteria including time period

Hi,

I would like to count the number of unique values/concepts (data on the left-hand side) based on the following criteria:
1. Category Code - it will only count the number of unique concepts for that category
2. Time Period - if I select from 1 to 3, then it should sum the number of unique concepts based on time periods 1-3. If I select from 3 to 3, then it would only count the number of unique concepts based on time period 3.

Sample file attached for reference.