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,