How to use COUNTIF with CODE function?

In the attached example, some cells contain an emoji checkmark. I can use the CODE function to confirm that the emoji in cell A1 corresponds to code 10003.


I want to count the number of cells in range A1:A4 that contain this specific emoji symbol. To do this, I am trying to use the COUNTIF function, but I can't seem to get the syntax right. Conceptually, I want to say "count the cells in the range A1:A4 that contain code 10003". In this example, the answer should be 3.


Can anyone suggest the correct syntax? Thx


MacBook Pro 13″, macOS 14.3

Posted on Feb 14, 2024 7:49 AM

Reply
4 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How to use COUNTIF with CODE function?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.