3 Criteria COUNTIFS returns as ZERO

Hey, life savers! I have a Gantt in Excel that countains some "words".

I need to have an account of how many of each term appears under 2 criterias...
I need to know how many "HO" we have on the Q2 of 2017; how many 100% on Q1 of 2018; etc
What I am using now is: =COUNTIFS(MasterData!BC11:OF47;$B5;MasterData!BC11:OF47;$C5;MasterData!BC11:OF47;D$4)

Using it like this, it returns as zero, but if I use each of of the criterias individually, works beautifully. What am I doing wrong????
Sending it attached for some enlighted soul to lend me a helping hand 
Gantt is on one tab and the dashboard is where I want to make the table

Nothing wrong. You can't use COUNTIFS to the same column with different criteria.
try:
=SUM(COUNTIF(MasterData!AI5:NL41,$B5),COUNTIF(MasterData!AI5:NL41,$C5),COUNTIF(MasterData!AI5:NL41,D$4))

Thanks, Sandy666, but this way it sums the individual counts, and it does not work with the criterias...
Not sure if my explanation was confused, but I need the count of HO on Q2, 2017 (which is 1), with your solution it gives 127, which is the sum of all HO (not only correspondent to Q2, 2017), all Q2 (no matter the year) and all 2017...

Could the problem be that my criterias are on rows and not columns????

Originally Posted by sandy666

Nothing wrong. You can't use COUNTIFS to the same column with different criteria.
try:
=SUM(COUNTIF(MasterData!AI5:NL41,$B5),COUNTIF(MasterData!AI5:NL41,$C5),COUNTIF(MasterData!AI5:NL41,D$4))

Thanks, Sandy666, but this way it sums the individual counts, and it does not work with the criterias...
Not sure if my explanation was confused, but I need the count of HO on Q2, 2017 (which is 1), with your solution it gives 127, which is the sum of all HO (not only correspondent to Q2, 2017), all Q2 (no matter the year) and all 2017...

Could the problem be that my criterias are on rows and not columns????

Originally Posted by sandy666

Is this what you want?
(I forgot add formula because of special kind of MOD )
=SUMPRODUCT(--(MasterData!$AI$5:$NL$5=K3)*--(MasterData!$AI$6:$NL$6=L3)*--(MasterData!AI5:NL41="HO"))

What have I said??? Life saver! Thanks a bunch @sandy666, you are awesome!

You are welcome

If that takes care of your original question, please click Add Reputation then select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Originally Posted by sandy666

You are welcome

If that takes care of your original question, please click Add Reputation then select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Super! Thanks ��

Thanks for rep and mark thread solved