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