Counting the results of a filtered column??
Posted by David on March 13, 2001 1:11 PM
I have data that I am filtering with an AutoFilter command. Unfiltered the result of the count is 12. After I filter, I count 5 hits, but the count is still showing as 12. I am using the countif formula. How can I correct the counts?? Thanks
Posted by Mark W. on March 13, 2001 1:26 PM
=SUBTOTAL(2,ref) is equivalent to COUNT()
=SUBTOTAL(3,ref) is equivalent to COUNTA()
