Count numbers [HELP]

Hi ruhat145 and welcome to the forum,

Here is another method that uses a helper column. See attached. There might be up to 6 ways to do this problem. DLL above used a text function of RIGHT to grab the right most character of each string in Col A (from row 2 to 1000) and tested it to be a zero.