Getting wrong output countifs formula

Hi friends,
I’m not getting correct output in the attached workbook.
I want to count the entries of remarks in the particular state-district matching.

Any help will be highly appreciated.

Thanking you,

Try:
=IF($P9="","",COUNTIFS(Personal!$I$9:$I$5000,$P$6,Personal!$AI$9:$AI$5000,"ExpiredMSI",Personal!$J$9:$J$5000,Office!$P9))