counting in an Autofilter

[mach3]

i have an autofilter column which contains either 0 or 1. so i can filter out all the 1's, all the 0's, or keep ALL.

for example:
with ALL, i have 100 rows.
with 1, i have 70 rows.
with 0, i have 30 rows.

i tried using a =count and an =counta function to try to count how many rows are not filtered out.

however, all the functions i use return 100; i guess the function is counting the filtered out rows as well. how can i get the proper count? please help.


mach3

 

[IML]

you could use
=SUBTOTAL(2,A2:A101)

good luck

 

[mach3]

thanks. that's what i was looking for.



mach3