Count function in Auto-Filtered data

C

Chart blues

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,
 
R

RonaldoOneNil

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