My Countifs formula doesn't work; Always showing "0".

Hi guys, I need your help. Can you guys detect error in my countifs formula? I have 4 categories and this same formula works on 2 categories but failed on the other 2. The result keeps showing "0".
Please Kindly Help me

=COUNTIFS(Rating!$I$2:$I$10454,'Answer Rating 1'!A3,Rating!$H$2:$H$10454,'Answer Rating 1'!$D$2)

Thank you for your help, I really appreciate it!

Welcome to the forum.

There is nothing inherently wrong with the formula, so it is the data that is the issue.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

As we don't know what is in columns I and H, nor what is in the Answer Rating cells, it's hard to guess.

As Ali says, doesn't look to be anything wrong with the formula so it must be the data. So, it could be that there are trailing spaces. Or, maybe, you have text values that look like numbers but won't match true numbers. That could be the result of using CONCATENATE, LEFT, RIGHT, or MID functions.

yes, I've been using MID function as one of the dataset for criteria_range2. But there seems to be no problem with the other 2 categories (the dataset also used MID function). What did I miss? Please help me, here I attached a little mock up

In H2 copied down:

=MID(G2,FIND(" ",G2)+1,10)

Does this make the table return the expected results?

The one you were using left leading spaces.

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

You're welcome. Thanks for the rep.

Just one point that you might find helpful: if you remove the Centre formatting on columns G and H, you can immediately see the misalignment caused by the leading space (from the MID function).

You're welcome.