If COUNTA is not working and showing you the wrong results. There may be some cells that look empty but actually contain some value, like space. COUNTA counts all the cells that are not empty. Hence, in this case, Excel is displaying the wrong result.