count

[alexm999]

I have a list of data in 5 columns. I know how to setup an autofilte
and even have it add up just the specific columns for totals... But
how do i have it count specific data while i filter it

 

[Frank Kabel]

Hi
have a look at SUBTOTAL. e.g.
=SUBTOTAL(3,A1:A1000)