Share via

COUNTIF over counting

Anonymous
2019-11-21T22:16:12+00:00

I've been reading about Excel COUNTIF function under counting problems, but mine is over counting by 1.  For example, COUNTIF(A1:A200, "Y").  I manually count the "Y" entries in the column and yielded one less than the return value of the function.  I went through all the blanks entires and deleted any possible hidden characters.  Still the same result.  What could be happening?

I have Microsoft Excel for Mac, version 16.16.15.  Thanks.

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-11-22T09:30:48+00:00

    Typical causes....

    • Hidden rows
    • Y entries that are coloured white so appear invisible!
    • Y entries with spaces before or after - these are invisible but will cause your problem.  So many people make cell entries followed by a space instead of tapping Enter.  Use the TRIM function on A1:A200 - my money is on that

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments