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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNTIF Function on filtered data 2
Numbering Rows in Filtered Data - Excel 2002 3
count filtered data 1
Excel Count of Consecutive Data 0
Auto filter count 3
Auto filter for multiple columns 2
Saving Auto-Filtered Data (or deleting the rest) 3
Count with Auto-Filter On 5

Top