How to get 0 instead of word 'False' in formula output?

Hi friends,

There is a list of states in column ‘I’ on personal sheet.
There is a list of districts in column ‘J’ on personal sheet.
There is a remark in column ‘AI’ on personal sheet.

I want to count the remark ‘ExpiredMSI’ on ‘Office’ sheet in column ‘S’.
It should match the state name in cell ‘P6’ and the districts of it in column ‘P’ from row 9.

The formula is giving correct output if the match criteria is matching but if it’s not matching then it produces ‘false’ output in the column ‘S’ which I don’t want. If the criteria is not match then I want output ‘0’ zero instead of ‘false’ word.

Any help will be highly appreciated.

Thanking you,

Hi mso3,

You are missing the False argument in your IF formula... Try this:

Please Login or Register  to view this content.

Hello GC Excel,

Thank you for the formula but now it's showing 0 output if the criteria is not match but not giving correct output in this case 2.

I want the count output if the criteria is match and 0 output if the criteria not match.

Thank you.

seems to work for me?
T9=IF($P9="","",IF(Personal!$I$9:$I$5000=$P$6,COUNTIFS(Personal!$AI$9:$AI$5000,"ExpiredMSI",Personal!$J$9:$J$5000,Office!$P9),0))

Hi GC EXCEL,
Sorry, I pasted the formula in row 9 so the error occur. The formula is perfect as per requirement.

Hi Ford,
Thank you for pointing out my mistake. I didn't saw that the row reference was row 10 so there was a error.

Thank you to both of you for your kind assistance to solve the problem.

Have a nice time.

Thats OK, I did teh exact same thing - put it row 9, but it was referencing row 10

Im happy you got it resolved

Oups. Sorry about the confusion.
I tried the formula where the result was FALSE (in row 10) and I changed it from there.

Thanks for the feedback