If your range is A1:A1000 then instead of using the COUNTA function, use
=SUBTOTAL(3,A1:A1000)

"Chart blues" wrote:

I'm using the auto-filter option in my data base and need to count the number
of cells (either numbers or text) selected and when I use the COUNTA function
it doesn't give me the correct number. I think the problem may be caused by
the filtering option which alters the row numbering (not consecutive).

Can someone help with this problem,please?

Thanks,