Share via

CountIF returning 0 for in Excel 2016 for Mac

Anonymous
2017-03-30T08:28:24+00:00

Hello everyone, 

Excel keeps returning 0 when I use the COUNTIF function. This has really been an annoying problem. I will provide a example with pictures so you can see it for your selves. Why is this happening? Please help. I'm not necessarily interested in alternatives to get the value. I'm interested in why is Excel doing this to me :( 

Here is the screenshot for the correct COUNTIF value of "No"

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2017-04-10T11:01:37+00:00

    If using "*" gives the correct results and without using "*" does not, this means there are some additional characters. Using "Yes" will search for only Yes, while "*Yes*" will search for any string of which Yes is a part of (ie. " Yes", or "Yes ", "Ayes", etc.). 

    To determine this will need to look at your excel file and in case you can upload the same.

    Regards

    4 people found this answer helpful.
    0 comments

9 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-04-11T20:18:18+00:00

    Hi Gui,

    Is there any update? Have you checked the suggestion from Phillip?

    Regards,

    Tim

    0 comments